DataLoader/MX Reference Manual (G06.24+)

Creating a Customized Version of DataLoader/MX
DataLoader/MX Reference Manual—525872-002
5-41
Example
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
DataLoader/MX installation directory can be specified by setting the environment
variable DL_INSTALL_DIR to point to the installation directory. For example:
$ export DL_INSTALL_DIR="/usr/opt/dataloader"
You can set the environment variable DL_COMP_OPTION to specify options that
need to be passed to the c89 or nmcobol language compiler during source
compilation. For example:
$ export DL_COMP_OPTION="-Wsql=CHAR_AS_ARRAY"
If you have multiple source files containing various exit routines, you must
language compile them individually, link them together into a library, and give the
library file as input to build.sh.
Example
To create your own version of DataLoader/MX:
1. Create the source code for the user exits you want to replace.
Make a copy of the source for the default exits, remove the code for the exits you
do not need to replace, and modify the code for the ones you want to change. The
source files that contain the default user exits are included with the DataLoader/MX
package:
•
sexits.c for C code
•
sexitscb.cob for COBOL code
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.