beautypg.com

Deleteonerror, Discards, Enabletriggers – HP Neoview Release 2.3 Software User Manual

Page 48: Endseq, Deleteonerror discards enabletriggers endseq

background image

Specifies the data source name for ODBC and 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 50)

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

The default value is 1000.

For a job where the

“parallel” (page 52)

option is “true”:

When the number of records written to the baddatafile file for the job reaches number,
Transporter stops processing the job.

For a job where the

“parallel” (page 52)

option is “false”:

When the number of records written to the baddatafile file for a job entry reaches number,
Transporter stops processing the job entry.

If number is zero, this option is disabled. Transporter does not stop processing a job or job entry
based on the number of discarded records.

Example:

discard = 2000

Tells Transporter to stop the job after 2000 discards.

enabletriggers

enabletriggers = "true" | "false"

The default is “false”.

If you want to enable triggers on a table during load jobs, set this option to “true”.

If you want to disable triggers on a table during load jobs, set this option to “false”.

This option is ignored for extract operations.

endseq

endseq = "sequence of characters"

endseq

, along with the

“startseq” (page 53)

option, are specific to named pipe sources and allow

specification of start and end sequence records.

48

Control File Options