Selecting the extract file format
The general format of the extract output file can be controlled by specifying one of three values that are available for the EXTRACT_FORMAT keyword.
As summarized in the following table, each available choice enables a different set of more detailed options for tailoring extract output. Certain functions that affect record layout as well as the output data are available only for particular extract file formats.
Data extract tailoring options according to value specified for EXTRACT_FORMAT keyword
Function | Value specified for EXTRACT_FORMAT keyword | ||
|---|---|---|---|
EXTRACT | HDUNLOAD | USER | |
Selecting segments for input | INCLUDE EXCLUDE SEGMENT WHERE SAMPLE_LIMIT SAMPLE_INTERVAL | INCLUDE EXCLUDE SEGMENT WHERE SAMPLE_LIMIT SAMPLE_INTERVAL | INCLUDE EXCLUDE SEGMENT WHERE SAMPLE_LIMIT SAMPLE_INTERVAL |
Outputting segment records (controlling the generation of segment records to the output file) | OUTPUT SEGMENT WHERE | OUTPUT SEGMENT * WHERE * Limited user control because of hierarchal path restrictions imposed by HDUNLOAD format | OUTPUT SEGMENT WHERE |
Controlling the content of output segment records | OUTPUT FIELDS WHERE | OUTPUT FIELDS WHERE | OUTPUT FIELDS WHERE |
Controlling content of the segment record prefix | No user control; standard EXTRACT format is used. | No user control; standard HDUNLOAD format is used | SEGMENT_RECORD_PREFIX |
Controlling content of the segment record suffix | No user control; no suffix is generated. | No user control; no suffix is generated | SEGMENT_RECORD_SUFFIX |
Controlling header records | No user control; standard EXTRACT header records are generated. | No user control; standard HDUNLOAD header records are generated | USER_RECORD BREAK FIELDS |
Controlling trailer records | No user control; no trailer records are generated. | No user control; standard HDUNLOAD trailer records are generated | USER_RECORD BREAK FIELDS |
Sorting the extract file | SORT SORT_OPTION | Not applicable | Not applicable |
This section contains the following topics:
Related topic