DB2 (z/OS® ODBC) Adapter commands

Use the adapter commands when specifying data sources and targets. The applicability of many of the commands depends upon whether you are specifying a source or target, whether a database/query file (.mdq) is used, and the situations in which the usage of the command applies.

Adapter commands can be used in GET > Source > Command or PUT > Target > Command settings in the Map Designer and Integration Flow Designer, using GET, PUT, DBLOOKUP, or DBQUERY function calls, or overriding a data source or target using execution commands in a RUN function or on the command line.

If connectivity to the mainframe-based DB2® is available, you can:

  • View DB2 host database table names directly from Database Interface Designer
  • Build type trees for DB2 host tables without using MTSMAKER
  • Test maps on your workstation