HP Neoview Release 2.5 Software - Manual (Page 53)

6 Control File Options
autotran
autotran = "true" | "false"
The default is “false”, except for pipe sources, in which case the default is “true”.
For a load operation: when this option is set to “false”, Transporter executes each statement
in a global transaction.
For a load operation: when this option is set to “true”, Transporter uses an independent
transaction for each insert.
NOTE: If a job fails with autotran set to true, it cannot be recovered.
If before-triggers exist on the target table, “enabletriggers” (page 55) must be set to false (the
default).
You can specify this option at the global or job level.
This option is ignored for extract operations.
baddatafile
baddatafile = filename
The default value is log/java/jobname_badrecord.dat.
For a load operation, this option specifies where to put source records that fail internal processing
before being written to the database. For example, a record that only contains 6 fields while 8
fields are expected.
Load records written baddatafile appear in the same format as the source file.
For an extract operation, this option specifies where to put records retrieved from the Neoview
database that could not be properly written into the target format. For example, the database
value is a string of ten characters but a fixed-width format of only eight characters is specified
for the target file.
The record format for extract records written to baddatafile are:
• Delimited format
• Field separator is comma
• Record separator is the system EOL separator
• Quoting character is a double-quote
commitsize
commitsize = number
The default value is 100,000.
This option is used for a load operation. It specifies the number of source rows to be processed
in a single transaction.
Some loads are non-transactional. This option does not apply to non-transactional loads.
number must be an integer greater than zero.
This option is ignored for extract operations.
compression
compression = "true" | "false"
The default value is true.
autotran 53