SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—640322-001
2-4
Embedded-Only SQL/MX Statements
Use these statements to compile an SQL statement and then execute the statement
any number of times within the current session:
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:
EXECUTE Statement on page 2-138 Executes an SQL statement previously compiled by
the PREPARE statement.
PREPARE Statement
on page 2-183 Compiles an SQL statement for later execution with
EXECUTE.
LOCK TABLE Statement
on
page 2-180
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-188
Registers a catalog on a remote node.
UNLOCK TABLE Statement
on
page 2-251
Releases locks held on the specified nonaudited
table or view.
UNREGISTER CATALOG Statement
on page 2-252
Removes an empty catalog reference from a node.
UPDATE STATISTICS Statement
on
page 2-266
Updates statistics about the contents of a table and
its indexes.
CONTROL QUERY DEFAULT
Statement on page 2-34
Overrides the contents of the SYSTEM_DEFAULTS
table for the current session.
CONTROL QUERY SHAPE
Statement on page 2-36
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-240
Specifies a dynamic timeout value in the run-time
environment of the current session.