Software Owner's manual

an empty string. For all other types, a field containing only white space is rejected and the
record is written to the “baddatafile” (page 47) file.
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"
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
This option is ignored for extract operations.
parallel
parallel = "true" | "false"
“true” — all job entries of a given job execute in parallel
“false” — all job entries of a given job execute serially
The default is “false”.
parallelstreams
parallel = number
This option specifies the number of data connections Transporter establishes for accessing the
Neoview database.
number must be an integer greater than or equal to one.
For a load operation or a TABLE extract operation:
• Transporter internally limits the maximum value of parallelstreams to the number of
partitions for the table.
• If this option is not specified, Transporter establishes one data connection for every four
partitions of the table.
For a Neoview SQL extract operation:
• Transporter internally limits the maximum value of parallelstreams to the number of
CPUs on the Neoview system.
• If this option is not specified, Transporter establishes one data connection for every four
CPUs on the Neoview system.
password
password = "password" | ${referencename | $E{referencename}
This option is required.
52 Control File Options