Parallel query options
- Default value
- Parameter type
- Where set
- By any user
- Related products
- Model 204 V3.2.1
Whether Parallel Query Option/204 users have limited multiple-node update capability
This parameter enables PQO multiple-node updates, but only for the DELETE RECORDS and FILE RECORDS User Language statements.
Valid PQOOPT settings are:
|0||Only single-node updates are allowed.|
|1||Multinode updates allowed with User Language statements DELETE RECORDS and FILE RECORDS.|
If PQOOPT is set for single-node updates, DELETE RECORDS can be used in scattered group context only if one or both of the following is true:
- All group members reside on the same node.
- The set of records referenced by DELETE RECORDS was created with a statement using an IN GROUP MEMBER clause.
If PQOOPT is set for single-node updates, FILE RECORDS can be used in scattered group context only if all group members reside on the same node.