Use the DB2 Export utility function to export data from a DB2 table or view to a sequential or VSAM file.
This page details the mapping of fields to batch parameters and miscellaneous notes. For the full description of each parameter, refer to the IBM File ManagerĀ® Users Guide and Reference for DB2.
Limitations
- The destination data set must exist.
- Non printable characters can not be specified as a CSV delimiter.
Basic Settings
DB2 Subsystem - specify the DB2 subsystem by its 4 character subsystem identifier. Specifying an invalid subsystem here will cause the function to fail with a message similar to FMNDB060 Unable to load DB2 Interface module DSNALI Abend Code 0806-0004. Check STEPLIB/LINKLIST for DB2 load libraries.

Parameter mappings:
- Source Owner - OBJIOWNR
- Source Name - OBJINAME
- Source Template - TMIN
- Destination Data set - OBJOOWNR
- Destination Template - TMOUT
- Data Format SQLDA - DATAFORMAT=SQLDA
- Data Format DB2 UNLOAD - DATAFORMAT=UNLOAD
- Data Format DSNTIAUL - DATAFORMAT=DSNTIAUL
- Data Format User defined - DATAFORMAT=USER
- Data Format CSV - DATAFORMAT=CSV
- Number of rows to export - ROWS
- Process unicode data natively - NATIVE
Back to top
Advanced Settings
This page is only available when the data format has been set to User defined or CSV.

Parameter mappings:
- Print null indicator - NIUSAGE=SEPARATE (if unticked, NIUSAGE=NONE)
- Null indicator character - NIINTEGER if an integer is specified, NICHAR otherwise
- Indicator placement Before column - PLACE=BEFORE
- Indicator placement After column - PLACE=AFTER
- Indicator placement Use template mapping - PLACE=USER
- Decimal format Internal packed decimal - DECIMAL=INTERNAL
- Decimal format Zoned decimal digits - DECIMAL=ZONED
- Decimal format Convert to strings - DECIMAL=EXTERNAL
- Convert integer columns to strings - INTEGER=EXTERNAL
- Convert floating point columns to strings - FLOAT=EXTERNAL
- Enclose graphic data columns in sosi characters - SOSI=YES
- CSV Delimiter - SEPARATOR
- Print column headers - CSVHDR=YES
- Include leading blanks - LEADING=YES
- Include trailing blanks - TRAILING=YES (requires a version 15 host or later)
- Quoted values - QUOTED=YES (requires a version 15.1.2 host or later)
- Single quotes - SNGLQUOTE=YES (requires a version 15.1.2 host or later)
- Leading zeros - LZERO=YES (requires a version 15.1.2 host or later)
Back to top