Selecting the extract file format
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 (limited user control because of hierarchal path restrictions imposed by HDUNLOAD format) WHERE * | 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:
Comments
Log in or register to comment.