SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-4
Embedded-Only SQL/MX Statements
Embedded-Only SQL/MX Statements
For information on SQL/MX statements that you can use only in embedded SQL
programs, see Section 3, Embedded-Only SQL/MX Statements.
Resource Control and Optimization Statements
Use these statements to control access to an SQL/MX table and its indexes and to
catalogs on remote nodes:
Control Statements
Use these statements to control the execution default options, plans, and performance
of DML statements:
Object Naming Statements
Use these statements to set the value of the NAMETYPE attribute, which determines
whether the object naming is ANSI or NSK for the current session, and to specify
LOCK TABLE Statement on
page 2-160
Locks the specified table (or the underlying tables of
a view) and its associated indexes for the duration of
the active transaction.
REGISTER CATALOG Command
on
page 2-168
Registers a catalog on a remote node.
UNLOCK TABLE Statement
on
page 2-229
Releases locks held on the specified nonaudited
table or view.
UNREGISTER CATALOG Command
on page 2-230
Removes an empty catalog reference from a node.
UPDATE STATISTICS Statement
on
page 2-245
Updates statistics about the contents of a table and
its indexes.
CONTROL QUERY DEFAULT
Statement on page 2-35
Overrides the contents of the SYSTEM_DEFAULTS
table for the current session.
CONTROL QUERY SHAPE
Statement on page 2-37
Forces access plans by modifying the operator tree
for a prepared statement.
CONTROL TABLE Statement
on
page 2-48
Specifies a performance-related option for DML
accesses to a table or view.
SET TABLE TIMEOUT Statement
on
page 2-218
Specifies a dynamic timeout value in the run-time
environment of the current session.