Errors, Faileddatafile, Forcestaging – HP Neoview Release 2.3 Software User Manual
Page 49: Errors faileddatafile forcestaging
This is an optional feature to allow data synchronization between Transporter and your
applications.
The start and end sequence records are considered “substitute” records. Whenever one of these
records is written to the pipe (either by Transporter during an extract operation, or by the
application during a load operation), it is terminated by an appropriate record separator.
sequence of characters
should not contain a record separator.
For a load operation when a pipe is read, Transporter discards any records read until the
startseq
record is seen. Transporter stops reading records once the endseq record has been
seen.
For an extract operation, Transporter writes the startseq record into the pipe before the first
data record. After all records have been written, the endseq record is written. The endseq
record is written even if errors are encountered.
errors
errors = number
The default value is 1000.
•
For a job where the
option is “true”:
When the number of records written to the
file for the job reaches
number
, Transporter stops processing the job.
•
For a job where the
option is “false”:
When the number of records written to the
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 failed records.
This option is ignored for extract operations.
faileddatafile
faileddatafile = filename
The default value is:
current-working-directory/failedrecord.dat
For a load operation, this option specifies where to put source records that have a valid format
but could not be written to the Neoview database. For example, a record that fails a data
conversion step or violates a uniqueness constraint.
Load records written to faileddatafile appear in the same format as the source file.
This option is ignored for extract operations.
forcestaging
forcestaging = "true" | "false"
The default is “false”.
For a file or named pipe load source, this option specifies whether rows should be written to
internally-managed staging tables on the Neoview system before populating target tables. If the
option is not “insert”, the forcestaging setting is ignored and the
option is implicitly set to “false”.
This option is ignored for extract operations.
errors
49