- Change the values in the properties file used by the Loader. The properties file is located in the following directory:
MassLoadCustomizer.properties is located in the MassLoader.zip archive. Extract this file, rename it but keep the .properties extension, and place it in a directory that is in the classpath. Important: Do not remove or modify the existing MassLoadCustomizer.properties file.
ISeries_LODWCSDTA_Customizer.properties is located in the /QIBM/ProdData/CommerceServer56/properties directory. Copy this file to the WC_userdir/instances/instance_name/xml directory, rename the new file but keep the .properties extension, then make any necessary changes to the new file. Important: Do not remove or modify the original ISeries_LODWCSDTA_Customizer.properties file.
- Set the appropriate values for your database and operating system. To customize one of these items, remove the double-slash comment characters (//) that precede the command in the Loader customizer property file and modify the defaults.
- Database-connection command
DBConnectCommand = connect to {0} user {1} using {2};
where:
- 0
- database name
- 1
- database user
- 2
- user password
- Database load-table command
DBLoadTableCommand = load from {0} of del modified by coldel{1} chardel{2} insert into {3} ({4});
where:
- 0
- file name
- 1
- column delimiter
- 2
- character delimiter
- 3
- table name
- 4
- column names, separated by commas (,)
- Database-import command
DBImportCommand = import from {0} of del modified by coldel{1} chardel{2}insert_update into {3} ({4});
where:
- 0
- file name
- 1
- column delimiter
- 2
- character delimiter
- 3
- table name
- 4
- column names, separated by commas (,)
- Database load command
- You may also need to change the following values:
- Substituting a component
- ParserName
- Name of the parser to be used
- ValidatorName
- Name of the validator to be used
- FormatterName
- Name of the formatter to be used
- JDBCFormatterName
- Name of the formatter when the SQL import method is used
- WriterName
- Name of the writer to be used
- JDBCWriterName
- Name of the writer when the SQL import method is used
To replace the Loader's default writer (DefaultWriter) with the writer com.abc.writer.SpecialWriter, for example, specify the following in the Loader customizer property file:
WriterName = com.abc.writer.SpecialWriter
Modify the following properties in the Loader customizer property file with the sqlimport, load, import, or delete method:
/** * The connect string. */ ConnectStringID = jdbc:db2:// /** * The JDBC driver information. */ JDBCDriverName = com.ibm.db2.jdbc.app.DB2Driver DbVendorName=DB2/iSeries /** * Custom writer for load/import methods. */ WriterName=com.ibm.wca.MassLoader.Writer.ISeriesWriter
- Substituting a component
- Setting the Loader to ignore elements in the input file
If your input file contains elements that do not map to the target database, you can set the Loader to ignore those elements in the Loader customizer property file. Use IgnoreElements to specify elements to ignore, and separate these elements with a semicolon (;). To ignore the import, literals, and ProductRepository elements, for example:
IgnoreElements = import;literals;ProductRepository
- Managing event queues
QueueLowCount = 35 QueueHighCount = 90
The source of the events filling the queue is blocked when the number of elements in the queue reaches the higher limit, preventing more events from queuing up. The queue begins accepting events again when the number of elements in the queue falls below the lower limit.
- Enabling the Loader to insert NULL into a column
EnableNULLCheck = true
For performance reasons, this feature is disabled by default.
Use the NULLStringLiteral property to determine the string representation of a null value within your data. To set the Loader so that the string "-" is used to represent a null value, for example, specify the following property and value in the Loader customizer property file:
NULLStringLiteral = -
By default, the value of this property is "NULL" (with no quotation marks).
- Set timestamp and date data masks
- Database-connection command