GET > source > command for DB2® (z/OS®) Adapter

Use the Map Designer or Integration Flow Designer to specify Database as the value for the GET > Source setting and enter the database-specific adapter commands as desired for the Command setting.

Database command options when there is a database/query file:

'' '[-DBTYPE DB2MVS]
[-SOURCE datasource]
[-STMT SQL_statement]
[-VAR name=value...]
[-CSTMT [number]]
[{-TRACE [file|ERROR]}]' ''

Database command options when there is no database/query file:

'' '-DBTYPE ODBC 
-STMT SQL_statement 
[-SOURCE datasource]
[-VAR name=value...]
[-CSTMT [number]]
[{-TRACE [file|ERROR]}]' ''