PUT > target > command for DB2® (z/OS®) Adapter

Use the Map Designer or Integration Flow Designer to specify Database as the value for the PUT > Target setting and enter the adapter commands as desired for the Command setting.

The adapter commands are shown using a single quotation mark, which is the Windows syntax. For non-Windows platforms, use two single quotation marks followed by one single quotation mark and end with one single quotation mark followed by two single quotation marks.

Database command options when there is a database/query file Database command options when there is no database/query file 
'' '[-DBTYPE DB2MVS]
[-SOURCE datasource] 
[-TABLE table_name] 
[-CSTMT [number]]
[-DELETE]   
[-UPDATE [OFF|ONLY]]   
[{-TRACE [file|ERROR]}]' ''
 
'' '-DBTYPE ODBC   
-TABLE table_name 
[-SOURCE datasource]   
[-CSTMT [number]]
[-DELETE]   
[{-TRACE [file|ERROR]}]' ''