beautypg.com

Crossoveryear, Datasource, Deleteonerror – HP Neoview Release 2.5 Software User Manual

Page 54: Discards, Crossoveryear datasource deleteonerror discards

background image

This option is used for a load operation and uses a run-length encoding (RLE) algorithm to
compress data during staging table and nonaudited loads.

One of these options must be set to true for the load job:

“forcestaging” (page 59)

“noaudit” (page 61)

“inlinesort” (page 59)

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 (").

Specifies the data source name for JDBC connections to the Neoview system.

datasource_name

must be a server-side data source defined on the Neoview system.

Example:

datasource = "LOAD01"

Specifies a data source named LOAD01.

deleteonerror

deleteonerror = "true" | "false"

The default is “false”.

For an extract operation: when this option is set to “false”, Transporter does not delete target
files or intermediate files when the operation terminates due to an error.

For an extract operation: when this option is set to “true”, Transporter deletes target files and
intermediate files when the operation terminates due to an error.

See the description of the

“multipart” (page 60)

option for more detail on intermediate files

created by Transporter.

This option is ignored for load operations.

For extract operations where the target is a named pipe, this option applies only to intermediate
files. Transporter never attempts to delete target pipes.

discards

discards = number

54

Control File Options