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

Creating a Customized Version of DataLoader/MX
DataLoader/MX Reference Manual—543544-001
5-41
Building a Customized Version of DataLoader/MX
build.sh can also SQL compile the customized object file (required if your custom
user exits contain embedded SQL). To use the build.sh routine with
DataLoader/MX, use this syntax:
user_exits
is the name of the user exits source or object file. The file extension must be one
of:
•
.c (C source)
•
.cbl or .cob (COBOL source)
•
.o (object file)
outfile
is the name of the customized DataLoader executable that is generated. By
default, the file is named dtload.
MX|MP
specifies whether SQL compilation is to be performed on the customized
DataLoader executable. By default, no SQL compilation is performed. If the
argument is MX, steps for SQL/MX SQL compilation are performed. If it is MP,
steps for SQL/MP SQL compilation are performed. In case of SQL/MX SQL
compilation, the mxsqlc or mxsqlco preprocessing is done and followed by the
mxCompileUserModule module compilation.
If SQL/MP SQL compilation is to be performed, the DataLoader executable must
be registered in a SQL/MP catalog. Specify the location of this catalog by setting
the environment variable DL_MP_CATALOG before running build.sh. For
example:
$ export DL_MP_CATALOG="\$catvol.catsubv"
By default, the build.sh script assumes that DataLoader/MX is installed in the
/usr/tandem/dataloader directory. If not, you can specify the location of the
build.sh user_exits [outfile [MX|MP]]
Note. To perform a customized DataLoader build with the MX option and for
DataLoader/MX utility functions to work properly, perform module definition file compilation
immediately after DataLoader/MX installation. In preparation, change to the
DataLoader/MX installation directory, ensuring that sufficient privileges are available for the
user. Run the command:
$ mxCompileUserModule dataload
For more information about module definition file compilation, see the SQL/MX
Programming Manual for C and COBOL.