Dataloader/MP Reference Manual

Creating a Customized Version of DataLoader/MP
DataLoader/MP Reference Manual—424148-003
5-36
Sorting With DTLSort
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.
(UPS nnn)
If supplied, nnn is the amount of memory, in kilobytes, to use for the work space for
UPS. If omitted, the UPS feature is not enabled.
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.