HP Neoview Release 2.3 Software - Manual (Page 47)

6 Control File Options
baddatafile
baddatafile = filename
The default value is current-working-directory/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.
crossoveryear
crossoveryear = number
There is no default value. If crossoveryear is not specified, this option is ignored.
Applies only to date values in source records for a load operation. This option is ignored for
extract operations.
When a date value is to be interpreted according to a data format specified in the control file and
the data format uses a two-digit year instead of a four-digit year, the crossoveryear specifies
the year the century changes from 20 back to 19.
number must be an integer in the range from zero to 99.
For example, to specify that all two-digit years below 50 be under the century 20, and all years
greater than or equal to 50 be under century 19:
crossoveryear = 50
datasource
datasource = "datasource_name"
The default value is “Admin_Load_DataSource”. Enclose the data source name in double
quotes (").
baddatafile 47