PQOOPT parameter

From m204wiki
Revision as of 15:05, 16 March 2017 by DCameron (talk | contribs) (→‎Description)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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:

SettingMeaning
0Only single-node updates are allowed.
1Multinode 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.