Forcestaging, Inlinesort, Loadid – HP Neoview Release 2.5 Software User Manual
Page 59: Forcestaging inlinesort loadid
The default value is log/java/jobname_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.
This option is supported for table synonyms but not supported for views.
This option can be specified at the global level or for individual file or pipe sources that are part
of a load operation. When the
option is set to "true" for a given job, all
sources within the job must have the same forcestaging setting.
For a load source where the
option for the job is “insert”, the
forcestaging
, inlinesort, and
options cannot be "true". If the
option is "true", the forcestaging option must be “false”, otherwise an
error is returned.
Because the operation is non-transactional, the
option is ignored.
When forcestaging is set to "true", SQL expressions and constant entries in the
section are not supported.
When staging tables are used for an “insert” operation:
•
Each target table has its own staging table.
•
The names of staging tables are generated by Transporter and written to the Transporter
log.
•
Source rows are first written to staging tables. When all source rows for a given target table
have been written to the staging table, Transporter populates the target table.
•
Jobs using staging tables cannot be recovered if the failure occurs during the staging table
to target table row transfer.
inlinesort
inlinesort = "true" | "false"
The default is “false”.
Setting this option to “true” enables Transporter to:
•
Use Enhanced Initial Load (EIL) – a faster, one-step load process without involving staging
tables.
•
Create and use exception tables for reporting non-fatal load errors.
This option must be “true” to enable EIL.
If this option is set to true, the
option must also be set to true.
loadid
loadid = number
forcestaging
59