SORT_SEQUENCE
Available parameters can be specified on the SORT_SEQUENCE keyword to customize the sorting sequence of root anchor points (RAPs), root key values, and logical SDEPs defined in the unload file.
Use
SORT_SEQUENCE is a required keyword for the PFPSORT command.
Syntax
SORT_SEQUENCE=(RAPparameter, KEYparameter, SDEPSEQ=parameter)
SORT_SEQUENCE=RELATIVE_RAP
Parameters
You must specify at least one of the following four values for either theRAPparameter or the KEYparameter:
Value | Description |
---|---|
KEY_ASCEND | Sort the file in ascending sequence by root key. |
KEY_DESCEND | Sort the file in descending sequence by root key. |
RAP_ASCEND | Sort the file in ascending sequence by RAP. |
RAP_DESCEND | Sort the file in descending sequence by RAP. |
If you specify a RAPparameter value and a KEYparameter value, the file will be sorted first by RAP and then by key within the RAP.
The optional SDEPSEQ parameter is used for specifying the sort sequence when logical SDEPs are defined in the unload file. Specify one of the following values for the SDEPSEQ-parameter:
Value | Description |
---|---|
FIFO (default) | Specify that the first SDEP segment inserted by the unload utility will be the first SDEP segment retrieved by IMS using GN processing. This value is ignored when physical SDEPs are defined in the unload file. |
LIFO | Specify that the first SDEP segment inserted by the unload utility will be the last SDEP segment retrieved by IMS using GN processing (the SDEP segments are in reverse order). This value is invalid when physical SDEPs are defined in the unload file. |
RELATIVE_RAP sorts the file by using only the relative RAP. The sort sequence is the same as that provided by the RELOAD command. Use RELATIVE_RAP to process files that are in a file format that is compatible with the IBM HD Reorganization Unload Utility (HDUNLOAD). If you are processing files in a different format, RELATIVE_RAP sorts the file in ascending sequence by RAP.
Default
None
Alias
SORTSEQ
Comments
Log in or register to comment.