Neoview Transporter User Guide (R2.5)

For an extract operation:
• This option specifies the character string that should be written to targets to represent NULL
values.
• For delimited data formats, if nullstring is not specified, Transporter does not write any
data characters to the target field to represent a NULL value.
• For fixed-width data formats, if nullstring is not specified, Transporter rejects any
retrieved record containing NULL values and writes the record to the baddatafile file.
operation
operation = "insert" | "update" | "upsert" | "delete"
The default is “insert”.
For a load operation, this option specifies the type of Neoview SQL operation to be performed:
• “insert” – inserts data into a Neoview SQL table
• “update” – updates data in a Neoview SQL table
• “upsert” – updates data in a Neoview SQL table if the data exists, otherwise inserts data
• "delete" — deletes data from a Neoview SQL table, if the data matching the WHERE
clause exists; otherwise, does nothing
This option is ignored for extract operations.
"upsert" is not supported on tables with triggers enabled.
parallel
parallel = "true" | "false"
“true” — all job entries for load jobs execute in parallel
“false” — all job entries of a given job execute serially
The default is “false”.
This option does not apply to extract jobs. All extract job entries are executed serially.
parallelstreams
parallelstreams = number
This option specifies the number of data connections Transporter establishes for accessing the
Neoview database for extract jobs.
For load jobs, parallelstreams in combination with “teamsize” (page 65) (parallelstreams *
teamsize) specifies the number of data connections Transporter establishes for accessing the
Neoview database.
number must be:
• An integer greater than or equal to one.
• An integer less than or equal to the number of partitions on the table.
• A value such that parallelstreams * teamsize does not exceed the number of
partitions on the system.
For a load operation or a TABLE extract operation:
• Transporter internally limits the maximum value of parallelstreams to the number of
partitions of the table on the Neoview system.
• If this option is not specified, Transporter sets parallelstreams to the number of partitions
of the table on the Neoview system divided by four.
62 Control File Options