Page History
The IBM i and its integrated environment including the IBM i DB2 database offer some unique capabilities. Because the mapping tool is designed to support databases on a wide variety of platforms, some of the capabilities specific to the IBM i server present particular considerations for Transformation Maps that use IBM i DB2 database components. The following topics describe some of these considerations:
Using SQL SELECT Statements or SQL-WHERE Components in an IBM i DB2 Database Components
Transaction Control and IBM i DB2 Database Journaling
...
| Note |
|---|
The considerations described are based on using Altova MapForce version 2010 release 3. Earlier (or later) versions of the mapping tool may be subject to different considerations or may differ with respect to the specific features mentioned. |
| Anchor | ||||
|---|---|---|---|---|
|
In a typical IBM i environment, applications avoid hard-coded reference to specific libraries. This is a powerful feature that permits the same programs to be run using database tables and other objects in libraries that are determined by the run-time environment. LANSA Composer supports this feature in connection with Transformation Maps that use IBM i DB2 database tables as follows:
...
When you execute a Transformation Map that uses IBM i DB2 database tables, LANSA Composer prepares the JDBC connection according to the Database Configuration that you provide as a parameter to the Transformation Map. The Database Configuration specifies the library (or libraries) to use.
| Anchor | ||||
|---|---|---|---|---|
|
The mapping tool provides two features that allow you to enter SQL that will be executed by the Transformation Map:
...
In both cases, this occurs because ODBC cannot find the files because the library or libraries containing the files are not specified in the DSN. If this occurs, it will be necessary to use an ODBC DSN that specifies an appropriate library list. Refer to Library names in the DSN for more information.
| Anchor | ||||
|---|---|---|---|---|
|
When you define a Transformation Map that uses IBM i DB2 database tables, MapForce prompts you to select a specific library containing the files whose definitions you wish to use.
...
| Note |
|---|
If you use the system naming convention, you will have to select the option to connect via the ODBC API (instead of Natively) when prompted while adding the database component. Otherwise you will not be able to see or select your library name in the Add/Remove Tables window. |
| Anchor | ||||
|---|---|---|---|---|
|
You may use a database component, including an IBM i DB2 database component, as the source or target of a mapping.
...