DataLoader/MX Reference Manual (G06.24+)

Creating a Customized Version of DataLoader/MX
DataLoader/MX Reference Manual—525872-002
5-16
Data Conversion
(Most significant)
Bits 0-8 0
Bit 9 1 if input contains YYYY
Bit 10 1 if input contains MM
Bit 11 1 if input contains DD
Bit 12 1 if input contains HH
Bit 13 1 if input contains MM
Bit 14 1 if input contains SS
Bit 15 1 if input contains MSSSSS
(Least significant)
The internal form of a date or time requires 64 bits.
SQLCI LOAD/COPY requires that the timestamp be passed to it in the internal form.
To format the data to pass to import, use the Guardian procedure
INTERPRETTIMESTAMP on the internal form generated by
DTLExternalToInternalDatetime.
DTLPackedDecimalToASCII
This procedure converts a packed decimal field to an ASCII character string. The
resulting ASCII string always has a leading sign of + or –.
The syntax is:
The value returned by this procedure indicates the outcome of the conversion. A value
of 1 means that the conversion was successful, and a value of 0 (zero) means that the
input string was not a valid packed decimal field.
The resulting ASCII character string is always 2 * Len bytes long.
DTLPackedDecimalToLongLong
This procedure converts a packed decimal field to a 64-bit signed integer.
The syntax is:
The value returned by this procedure indicates the outcome of the conversion. A value
of 1 means that the conversion was successful. A value of 0 (zero) means that the
input string was not a valid packed decimal field. A value of -1 indicates that the input
is potentially too large to fit in a 64-bit integer. A packed decimal number can be as
large as 9,999,999,999,999,999,999,999,999,999,999, while the maximum 64-bit
long DTLPackedDecimalToASCII( char* PD, long Len,
char* ASCII );
short DTLPackedDecimalToLongLong(
char* PD,
long Len,
long long* Result
);