DataLoader/MX Reference Manual (G06.24+)

Creating a Customized Version of DataLoader/MX
DataLoader/MX Reference Manual—525872-002
5-36
Sorting With DTLSort
ASC or ASCENDING
directs DTLSort to sort in ascending order on this field.
DESC or DESCENDING
directs DTLSort to sort in descending order on this field.
startcol
is the starting column of the key field in bytes from the start of the record, counting
from 1.
endcol
is the ending column of the key field.
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.
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.