Formatting Optim High Performance Unload output
You can use the Optim™ High Performance Unload FORMAT clause to unload data into several different output formats.
- ASC format
- The ASC format generates undelimited or fixed length output.
If you specify the LOADFILE option in the control file, the ASC format can generate the LOAD command including the METHOD L statement. METHOD L specifies the start and end positions in the data file for each table column. The start position is specified as the byte location, in the load file, of the start of the data column to be loaded into the table column. The end position is specified as the byte location, in the load file, of the end of the data column to be loaded into the table column.
METHOD L is the only method available for ASC files. For more information, see the LOAD command in the IBM® Db2 ™ Command Reference.
- DEL and DELIMITED formats
- The DEL and DELIMITED formats are delimited ASCII formats.
The DEL format uses the same delimiter and column separator as Db2® Export. The DELIMITED format operates the same way as DEL except the DELIMITED format gives you the ability to specify the column separator, column value delimiter or the null column delimitation options. If no value is specified for any of the delimited format options, the DELIMITED format operates the same as DEL.
Refer to the Db2 publications for further information regarding the output of the Db2 Export command.
- DSNTIAUL format
- DSNTIAUL is an output that produces a format that allows the unloaded file to be loaded into Db2 for z/OS®.
The output format is a sequential file without row or column delimiters. This file consists of an unbroken sequence of fixed-length records.
- IXF format
- The PC version of the Integration Exchange Format (IXF) is a generic relational database exchange format.
- XML format
- The XML format is a file that consists of a sequence of records of variable length that are ordered by rows and columns. All of the records are string formatted with XML tags, and each record contains column names and column data.
The XML format supports all of the Db2 data types.