PQOOPT parameter: Difference between revisions
Jump to navigation
Jump to search
(Automatically generated page update) |
|||
| Line 11: | Line 11: | ||
<dd>All | <dd>All | ||
<dt>Introduced | <dt>Introduced | ||
<dd><var class="product">Model 204 | <dd><var class="product">Model 204 V3.2.1</var> | ||
</dl> | </dl> | ||
==Description== | ==Description== | ||
<p>Whether Parallel Query Option/204 users have limited multiple-node update capability</p> | <p>Whether Parallel Query Option/204 users have limited multiple-node update capability</p> | ||
Revision as of 16:24, 15 March 2017
Parallel query options
Summary
- Default value
- 0
- Parameter type
- User
- Where set
- By any user
- Related products
- All
- Introduced
- Model 204 V3.2.1
Description
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:
| Setting | Meaning |
|---|---|
| 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.