Overriding the onpload Database Values

Home | Previous Page | Next Page The onpload Utility >

Overriding the onpload Database Values

The options that are described in this section let you enter size information that overrides existing parameters in the onpload database.

Overriding the onpload

  Database Values:
 
|--+------------------+-----------------------------------------|
   +- -C--caseconvert-+
   +- -D--override_db-+
   +- -F--filter------+
   +- -L--trace_level-+
   +- -M--converters--+
   +- -R--rejectfile--+
   +- -S--servername--+
   +- -T--target_db---+
   '- -l--logfile-----'

Element	Purpose	Key Considerations
-C caseconvert	Sets the case-conversion option that converts all character information	Additional Information: If you do not set this option, no case conversion is done. Possible flags include: U or u = uppercase L or l = lowercase P or p = proper names blank = no conversion To use ipload, see Figure 92.
-D override_db	Overrides the database specified in the map used for the load	Additional Information: To use ipload, see Figure 87.
-F filter	Identifies the filter that onpload uses for screening load records	Additional Information: To use ipload, see Using a Filter.
-L trace_level	Sets the amount of information logged during the load	Restrictions: This option is available only from the command line. The value of trace_level must be an integer from `1` to `5`. Additional Information: The default value is `1`. Higher values result in more output. Do not use this option unless you are doing serious debugging.
-M converters	Sets the maximum number of conversion threads per device	Restrictions: This option is available only from the command line. Additional Information: This value overrides the value of CONVERTTHREADS set in the HPL configuration file (plconfig). If the value for converters is greater than `1`, onpload can dynamically allocate more conversion threads as needed to process data. References: For specific details on this option, see CONVERTVPS.
-R rejectfile	Identifies the file destination for rejected records	Additional Information: The file is named rejectfile.rej. To use ipload, see Figure 109.
-S servername	Sets the onpload database server	Restrictions: The onpload utility must be located on the same network as the onpload database and on the same server as the target database. You can only run jobs on remote database servers using the ipload utility. Additional Information: To use ipload, see Figure 45.
-T target_db	Sets the target database serve	Restrictions: The onpload utility must be located on the same network as the onpload database and on the same server as the target database. You can only run jobs on remote database servers using the ipload utility. Additional Information: To use ipload, see Figure 45.
-l logfile	Specifies the name of a file to which onpload sends messages	Additional Information: If you do not specify a log file, onpload sends messages to stdout. To use ipload, see Figure 104 and Figure 109.