Export to Fixed Format

This export format is useful for use with the DB2 z/OS load utility; this requires the data to be in fixed format, eg. each column has a fixed width.

export_fixed

Options that can be specified with this format are:

Option	Description
Generate Control File	For Fixed Format, you can also specify that a Control File is generated. This control file contains information on the start/end position of the columns in the export file.
Include blank between columns	Specifies whether a blank is to be written between columns in the output file.

Numeric variables are not padded on left with zeros (which is required for import into the DB2 z/OS load utility).
AQT currently doesn't generate the control statements for the DB2 z/OS load utility.
A maximum of 10,000 bytes of a column will be exported.

Advanced Query Tool