Hp Neoview Release 2.4 Software Bedienungsanleitung PDF herunterladen (Seite 57)

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. Whereas for load jobs, parallelstreams in combination with

“teamsize” (page 59) (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.

• A power of two if set to a value greater than one.

For a load operation or a TABLE extract operation:

• Transporter internally limits the maximum value of parallelstreams to the number of

partitions in the system divided by four, to the nearest power of two.

• If this option is not specified, Transporter sets parallelstreams to the number of partitions

on the Neoview system divided by four, to the nearest power of two.

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 sets parallelstreams to the number of CPUs

on the Neoview system divided by four, to the nearest power of two.

password

password = "password" | ${referencename | $E{referencename}

This option is required.

operation 57

1 2 ... 52 53 54 55 56 57 58 59 60 61 62 ... 123 124

Keine Kommentare

Hp Neoview Release 2.4 Software Bedienungsanleitung Seite 57