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

Creating a Customized Version of DataLoader/MX
DataLoader/MX Reference Manual—543544-001
5-16
Data Conversion
The value returned by this procedure indicates the outcome of the conversion, where
an error condition is indicated by:
If none of these errors occur, the result is a positive number composed of seven bits
indicating which of the seven possible components were actually present:
(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.
-1 The input is syntactically incorrect.
-2 The input is ambiguous.
-3 The day or date does not exist (for example, the 30th of
February).
long DTLPackedDecimalToASCII( char* PD, long Len,
char* ASCII );