NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-73
CONTROL TABLE Directive
to checkpoint unaudited writes, and what to do when encountering locked data or
unavailable partitions.
table
is the name of the table to which the control options apply (or an equivalent
DEFINE), exactly as the table name (or DEFINE name) appears in subsequent
references that are to be affected by the control options.
For example, if table is a fully qualified Guardian name, then the control options
apply to subsequent references that use the same fully qualified Guardian name. The
control options do not apply to references that use only the table name (even if the
name expands to the same fully qualified name) nor to references that use a
DEFINE name (even if the table associated with the DEFINE is the same table).
Similarly, if table is a DEFINE name, then the control options apply to
subsequent references that use the same DEFINE name. The control options do not
apply to references that specify a table name, even if the DEFINE value is the table
name.
{ table [ AS cor ] }
CONTROL TABLE { view [ AS cor ] [BASETABLE btcor] }
{ * }
[| ACCESS PATH { SYSTEM | PRIMARY | INDEX index } |]
[| [MDAM ON [USE {value|DEFAULT} [KEY] COLUMN[S]] |]
[| [ACCESS { SPARSE | DENSE | SYSTEM}] ] |]
[| |]
[| JOIN METHOD { NESTED | [KEY SEQUENCED] MERGE | |]
[| HASH | SYSTEM } |]
[| |]
[| JOIN SEQUENCE { SYSTEM | sequence-number } |]
[| |]
[| MDAM { OFF | ENABLE } |]
[| |]
[| OPEN { ALL | ACCESSED } [ PARTITIONS ] |]
[| |]
[| { RETURN | WAIT } IF LOCKED |]
[| |]
[| SEQUENTIAL [ INSERT|READ|UPDATE ] {ON|OFF|ENABLE} |]
[| |]
[| SEQUENTIAL BLOCKSPLIT [ FOR INSERT ] {ON|ENABLE} |]
[| |]
[| { SKIP | STOP AT } UNAVAILABLE PARTITION |]
[| |]
[| SYNCDEPTH { 0 | 1 } |]
[| |]
[| TABLELOCK { OFF | ON | ENABLE } |]
[| |]
[| TIMEOUT { value | DEFAULT } [ SECOND[S] ] |]