Configuring Loader package commands and scripts

To launch the Loader package and run its commands, use the scripts or commands provided in the WebSphere Commerce directory:

The scripts and commands are as follows:

AIXLinuxiSeriesSun Solaris Operating Environment

dtdgen.sh
DTD Generate shell script
idresgen.sh
ID Resolve shell script
massextract.sh
Extract shell script
massload.sh
Load shell script
txttransform.sh
Text Transform shell script
xmltransform.sh
XML Transform shell script

Windows

dtdgen.cmd
DTD Generate command
idresgen.cmd
ID Resolve command
massextract.cmd
Extract command
massload.cmd
Load command
txttransform.cmd
Text Transform command
xmltransform.cmd
XML Transform command

The scripts and commands provided in WebSphere Commerce as utilities for executing the Loader package commands, call on scripts and batch files containing environment-variable settings. These are the setenv, setdbenv.db2, and setdbenv.oracle files; and they are located in the following directories by default:

You may need to modify these files when you customize your system. Here are two examples:

  1. On a Windows operating system, you may need to change the values for one or more of the following paths in setenv.bat:
    • JAVA_HOME
    • DB2_DRIVER
    • ORACLE_HOME
    • ORACLE_DRIVER
    • ORACLE_CLASSPATH

    These environment variables are set in setenv.bat and used in setdbenv.db2.bat or setdbenv.oracle.bat, depending on the database that you are using.

  2. If you want to run the Loader command using Oracle 9i but the environment variables are pointing to your older Oracle 8i drivers, you may need to update three variables in the environment-setting files to point to the Oracle 9i drivers. For the Windows operating system, the new lines would look something like this:
      SET ORACLE_CLASSPATH=C:\oracle9\ora9\jdbc\lib\classes12.zip;
      SET ORACLE_DRIVER=C:\oracle9\ora9\jdbc\lib\classes12.zip; 
      SET ORACLE_HOME=C:\oracle9\ora9