DataLoader/MX Reference Manual (H06.03+, J06.03+)

Creating a Customized Version of DataLoader/MX
DataLoader/MX Reference Manual—543544-001
5-37
Sorting With DTLSort
length
is the number of bytes in the key field.
type
is the type of data the field contains:
If type is omitted, STRING is assumed.
To sort on a field that contains unsigned ASCII numeric data, use type STRING.
(UPS nnn)
If supplied, nnn is the amount of memory, in kilobytes, to use for the work space for
User Process Sort (UPS). If omitted, the UPS feature is not enabled.
For example:
asc 2:4 string, asc 5 for 4, desc 10 for 4 integer
describes the most significant key as a character string in columns 2 through 4, to
be sorted in ascending order; the second key as a character string (the default
type) in columns 5 through 8, again to be sorted in ascending order; and the least
significant key as a 4-byte binary integer in columns 10 through 13, to be sorted in
descending order.
The UPS feature of FastSort can speed up sorts of a small number of records by a
factor of 100. If all the records (together with the overhead) fit into the work space
STRING Ordinary alphanumeric data.
UPPER Alphanumeric data, but lowercase characters are
compared as if they were uppercase.
INTEGER Signed binary data.
REAL Floating point data.
UNSIGNED Unsigned binary data.
SLE or
SIGNED LEADING
EMBEDDED
Signed ASCII numeric data with the sign given by the
high-order bit of the first byte of the field. The length
cannot be more than 32.
SLS or
SIGNED LEADING
SEPARATE
Signed ASCII numeric data with the sign given as a “+”
or “-” in the first character of the field. The length cannot
be more than 32.
STE
or SIGNED TRAILING
EMBEDDED
Signed ASCII numeric data with the sign given by the
high-order bit of the last byte of the field. The length
cannot be more than 32.
STS
or SIGNED TRAILING
SEPARATE
Signed ASCII numeric data with the sign given as a “+”
or “-” in the last character of the field. The length cannot
be more than 32.