HP Neoview Release 2.5 Software - Manual (Page 72)

• The set of targets (that you have set in the “Sources” (page 45) section) must be the same
for all sources in the job.
• If multiple job entries specify the same target, either all mapnames specified by the job entries
must be identical, or they must use the same targetformat, the same fieldmappings,
and a sourceformat with identical field names and field order. See
“Maps” (page 41) for
details about mappings.
• For options specified at the job entry level, settings (explicit or default) must be identical for
all job entries.
• For options specified at the “Sources” (page 45) level, input data sources must have identical
settings (explicit or default) for these options:
— File and Named Pipe Sources
◦ “forcestaging” (page 59)
◦ “inlinesort” (page 59)
◦ “sorted” (page 63)
— JDBC Sources
◦ “datasource” (page 54)
◦ “noaudit” (page 61)
◦ “password” (page 63)
◦ “system” (page 64)
◦ “url” (page 65)
◦ “user” (page 66)
• Database connections and transactions managed internally by Transporter are shared by all
job entries.
• Rows from different sources can be processed in the same transaction. There is no guarantee
that a specific number of rows from a given source is included in each transaction.
• For non-SQL dataformats referenced by maps to a specific SQL target, the fields must have
identical names and be in the same order.
Considerations for Extract Jobs
While extract jobs are specified in the control file and run with load jobs in the same control file
invocation, there are these differences from load jobs:
• Extract jobs cannot be recovered.
• You cannot use staging tables with extract jobs.
• Database isolation levels are different, depending on the source:
— For a table source, Transporter issues queries with an isolation level of READ
UNCOMMITTED.
— For a Neoview SQL query source, Transporter issues queries with an isolation level of
READ COMMITTED. However, you can change the isolation level by explicitly
specifying it in the query.
• By default, Transporter processes extract jobs using enhancements that allow the fastest
possible processing. However, to enable Transporter to use “fast extract” processing, your
extract job must adhere to these guidelines:
— The dataformat must be delimited, not fixed-width.
— Map entries must NOT be constant, field expression, or default.
— Dataformats used in the map section of the control file must have the same field names
for both source and target.
72 Load and Extract Operations