|
VMS Help SORT, /KEY, Fields *Conan The Librarian |
POSITION:n
Specifies the position of the first byte in the key field. A
value of 1 to 32,767 may be specified. The first byte in a record
is considered position 1. The POSITION:n field must be specified.
(Note that the SIZE:n field must also be specified, except for
floating point data types where the size is known.)
SIZE:n
Specifies the length of the key field. The total composite size
of all keys and the original input record length must be less
than 32,767 bytes. If the decimal sign is stored in a separate
byte in the key field, that byte is not counted toward the size
of the data.
Both the POSITION:n and SIZE:n fields must be specified, except
for floating point data types where the size is known.
The data type of the key determines what values are acceptable
when specifying size as well as the units in which the size is
specified:
o 1 to 32,767 (characters) for character data
o 1, 2, 4, 8, or 16 (bytes) for binary data
High-performance Sort/Merge: The high-performance Sort/Merge
utility currently supports only 1, 2, 4, and 8-byte binary
keys.
o 1 to 31 (digits) for decimal data
o No value is necessary for floating point data
ASCENDING
Orders the sorting operation in ascending alphabetical or
numerical order. ASCENDING is the default order.
DESCENDING
Orders the sorting operation in descending alphabetical or
numerical order.
CHARACTER
Specifies character data in the key field. CHARACTER is the
default data type.
BINARY
Specifies binary data in the key field.
SIGNED
Specifies signed binary or decimal data in key field. SIGNED is
the default for binary and decimal data.
UNSIGNED
Specifies unsigned binary or decimal data in the key field.
F_FLOATING
Specifies F_FLOATING format data in the key field.
D_FLOATING
Specifies D_FLOATING format data in the key field.
G_FLOATING
Specifies G_FLOATING format data in the key field.
H_FLOATING
Specifies H_FLOATING format data in the key field.
High-performance Sort/Merge: Not supported by the high-
performance Sort/Merge utility.
S_FLOATING
On Alpha and I64 systems, specifies IEEE S_FLOATING format data
in the key field.
T_FLOATING
On Alpha and I64 systems, specifies IEEE T_FLOATING format data
in the key field.
DECIMAL
Specifies decimal data in the key field.
TRAILING_SIGN
Specifies trailing sign decimal data in the key field. TRAILING_
SIGN is the default for decimal data.
LEADING_SIGN
Specifies leading sign decimal data in the key field. The leading
sign must be in the first position of the field and the field
must be left zero padded.
OVERPUNCHED_SIGN
Specifies overpunched decimal data in the key field. OVERPUNCHED_
SIGN is the default for decimal data.
SEPARATE_SIGN
Specifies separate sign decimal data in the key field.
ZONED
Specifies zoned decimal data in the key field.
High-performance Sort/Merge: Not supported by the high-
performance Sort/Merge utility.
PACKED_DECIMAL
Specifies packed decimal data in the key field.
NUMBER:n
Specifies the order of priority of each key if you do not list
multiple keys in the order of their priority. A value of 1 to 255
may be specified.
|
|