DataLoader/MX Reference Manual (G06.24+)

Introduction to DataLoader/MX

DataLoader/MX Reference Manual—525872-002

1-3

Relationship to Other Loading Tools

DataLoader/MX is designed to complement other tools that load and maintain NonStop

SQL/MX databases. For example, the NonStop SQL/MX import utility is not, in itself,

parallel, but can be used in conjunction with DataLoader/MX to provide a parallel load

solution. In addition, DataLoader/MX can be customized to perform data format

transformations as required when using import for load operations.

DataLoader/MX provides features that are similar to those provided by DataLoader/MP,

another HP tool for loading databases. DataLoader/MP is designed for the Guardian

environment. It supports the maintenance of SQL/MP tables and Enscribe files.

DataLoader/MX has extensions to support working with SQL/MX in the OSS

environment. Also, because both DataLoader/MX and DataLoader/MP use Guardian

interprocessor communication (IPC) for communicating with other processes, it is

possible to create a loading scenario where both are used together.

Using DataLoader/MX With SQL/MP and

Enscribe

DataLoader/MX supports all of the features supported by DataLoader/MP. This manual

uses SQL/MX and import to illustrate the features of DataLoader/MX. The same

functionality can be obtained by using DataLoader/MX with SQL/MP or Enscribe and

SQLCI LOAD/COPY. The data format required by LOAD/COPY is different from what is

required by import. The customized user exits need to be modified to convert the

input data to SQLCI LOAD/COPY format rather than the import format.

DataLoader/MX supports having embedded SQL statements in the user-written exit

routines. These can be either SQL/MX or SQL/MP statements. The SQL error-handling

functions provided use different arguments if the customized build specifies that

SQL/MP SQL compilation is to be performed. SQL/MP requires the use of SQLCODE

and SQLCA, while SQL/MX works using SQLSTATE.