DataLoader/MX Reference Manual (G06.24+)

Creating a Customized Version of DataLoader/MX

DataLoader/MX Reference Manual—525872-002

5-14

DataLoader/MX Library

Use the DataLoader/MX library of utility routines to make writing user exits simpler.

With the exception of the User Messages routines, you can call the procedures from

any language.

Use the utility routines for these types of tasks:

•

Converting data from one format to another

•

Requesting sequential I/O operations

•

Communicating with the user through C

•

SQL error checking and statistics maintenance, after executing an embedded SQL

INSERT, UPDATE, or DELETE statement in a user exit

•

Generating test data

•

Sorting

•

Performing miscellaneous utility functions

This subsection describes the utility routines provided with DataLoader/MX, gives their

syntax, and provides examples for their use.

Data Conversion

These procedures provide data conversion capability. In addition to these routines, the

NonStop Kernel provides the MBCS_EXTERNAL_TO_TANDEM procedure for

conversion of multibyte character data, such as Kanji. For more information, see the

Guardian Procedure Calls Reference Manual.

DTLEBCDICToASCII

This procedure translates an EBCDIC character string to ASCII.

The syntax is:

DTLExternalToInternalDatetime

This procedure converts a character string containing a date and time to the internal

form suitable for processing by SQLCI LOAD.

void DTLEBDCICToASCII( char* EBCDIC, long Len );