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
Back to top