PQOOPT parameter: Difference between revisions

From m204wiki
Jump to navigation Jump to search
(Automatically generated page update)
(Automatically generated page update)
Line 1: Line 1:
{{Template:PQOOPT parameter subtitle}}
==Summary==
==Summary==
<dl>
<dl>

Revision as of 16:41, 27 August 2013

Parallel query options

Summary

Default value
0
Parameter type
User
Where set
By any user
Related products
All
Introduced
Model 204 V6.1 or earlier

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.