Problem Seeing Databases on AS 400 Using ODBC

On an AS/400, using Easylabel and retrieving data via ODBC, Easylabel saw 3 database files, now Easylabel only sees 2.

Previously, two of the three original physical database files were joined as a logical file. To solve an application issue, the customer changed the files on the AS/400 so that all three files were a logical join. After the change, this logical file could be read correctly as three separate database files under other applications, but not Easylabel.

On an AS/400, a file is created when using Easylabel, that is of the type SQLPKG (SQL-package). By removing this file before using Easylabel, the logical database file can be read correctly.