skip to main content
OpenEdge Data Management: DataServer for ODBC
The DataServer Tutorial : Migrating an OpenEdge database to an ODBC data source : Running the utility interactively : Migration considerations for DB2
 
Migration considerations for DB2
DB2 for iSeries uses a SQL "Collection" or native "Library" to qualify data object selection. This is in contrast to most SQL data sources that use the owner name of the user performing the migration to determine how to qualify objects migrated to the ODBC data source. Note that the user is prompted for an additional interface element, Collection/Library when the foreign DBMS type is DB2/400. The default value given to the Collection/Library is derived from the Data Source Name (DSN) properties of the DB2 UDB driver configuration. You can specify any valid native "Library" in the Collection/Library parameter however OpenEdge expects and Progress recommends that data objects in the foreign data source are defined to the SQL "Collection" specified in the DSN configuration. "Collections" are SQL-compliant so objects defined to them are also SQL-compliant by definition. Data object definitions retrieved from native iSeries libraries are expected to be SQL-compliant as well. Any native attributes of database object definitions retrieved from objects in DB2/400 for iSeries "libraries" are not inclusive in their schema holder definitions if those attributes are purely native, i.e., are not SQL-compliant attributes. Progress recommends defining all database objects from all native libraries you wish to define to an OpenEdge schema holder in a single collection that you also specify in your DSN configuration.
Alternatively, the iSeries Access for Windows native driver for iSeries may provide some native feature mapping not available with the branded DB2 UDB driver provided with OpenEdge. When the native driver is used, if not specified, the default "Collection/Library" name originates from the 'SQL Default Library' specified by the DSN. If 'SQL Default Library' is not specified but a 'Library List' is designated by the DSN, then the first library in the library list is designated as the default 'Collection/Library'. If neither of these values are specified by the DSN, then the user id of the user performing the dictionary action is used for the default 'Collection/Library' value.