Operation, Parallel, Parallelstreams – HP Neoview Release 2.5 Software User Manual
Page 62: Operation parallel parallelstreams
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
(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