Operation, Parallel, Parallelstreams – HP Neoview Release 2.3 Software User Manual
Page 52: Password, Operation parallel parallelstreams password
an empty string. For all other types, a field containing only white space is rejected and the
record is written to the
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