SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-4
Embedded-Only SQL/MX Statements
Embedded-Only SQL/MX Statements
For more 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:
LOCK TABLE Statement on
page 2-156
Locks the specified table (or the underlying tables of
a view) and its associated indexes for the duration of
the active transaction.
REGISTER CATALOG Statement
on
page 2-164
Registers a catalog on a remote node.
UNLOCK TABLE Statement
on
page 2-224
Releases locks held on the specified nonaudited
table or view.
UNREGISTER CATALOG Statement
on page 2-225
Removes an empty catalog reference from a node.
UPDATE STATISTICS Statement
on
page 2-239
Updates statistics about the contents of a table and
its indexes.
CONTROL QUERY DEFAULT
Statement on page 2-33
Overrides the contents of the SYSTEM_DEFAULTS
table for the current session.
CONTROL QUERY SHAPE
Statement on page 2-35
Forces access plans by modifying the operator tree
for a prepared statement.
CONTROL TABLE Statement
on
page 2-46
Specifies a performance-related option for DML
accesses to a table or view.
SET TABLE TIMEOUT Statement
on
page 2-214
Specifies a dynamic timeout value in the run-time
environment of the current session.