To launch the Loader package and run its commands, use the scripts or commands provided in the WebSphere Commerce directory:
WC_installdir/bin
/QIBM/ProdData/CommerceServer55/bin
Important: To run the scripts, launch a qshell command window by running the STRQSH command.WC_installdir\bin
The scripts and commands are as follows:
- 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
- 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:
- 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.
- 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