SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-5
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-200 Executes an SQL statement previously compiled by
the PREPARE statement.
An operation is a postfix merge if the
range of data ends at the bottom of
the partition. You can specify only
the TO NEXT PARTITION clause.
The split partition cannot be the last
partition (the rightmost partition in
the list). on page 2-278
Compiles an SQL statement for later execution with
EXECUTE.
LOCK TABLE Statement
on
page 2-267
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-314
Registers a catalog on a remote node.
UNLOCK TABLE Statement
on
page 2-382
Releases locks held on the specified nonaudited
table or view.
UNREGISTER CATALOG Statement
on page 2-383
Removes an empty catalog reference from a node.
UPDATE STATISTICS Statement
on
page 2-401
Updates statistics about the contents of a table and
its indexes.
CONTROL QUERY DEFAULT
Statement on page 2-60
Overrides the contents of the SYSTEM_DEFAULTS
table for the current session.