SQL/MX Programming Manual for C and COBOL (G06.24+, H06.03+)

Embedded SQL Statements
HP NonStop SQL/MX Programming Manual for C and COBOL—523627-004
2-11
Embedded SQL Declarations and Statements
Object Naming Statements (continued)
SET MPLOC* Sets default Guardian volume and
subvolume for unqualified physical object
names in dynamic SQL statements that are
prepared after this statement is executed.
The NAMETYPE must be set to NSK for this
command to work.
CONTROL QUERY DEFAULT* Modifies the content of the
SYSTEM_DEFAULTS table for the current
process. This statement is executable only
when you use it dynamically with PREPARE
and EXECUTE or with EXECUTE
IMMEDIATE. This statement affects only
dynamic statements that are prepared after
the execution of this statement.
CONTROL QUERY SHAPE* Forces execution plans by modifying the
operator tree for a prepared statement. This
statement is executable only when you use it
dynamically with PREPARE and EXECUTE
or with EXECUTE IMMEDIATE. This
statement affects only dynamic statements
that are prepared after the execution of this
statement.
CONTROL TABLE* Specifies a performance-related option for
DML accesses to a table or view. The
options are MDAM, PRIORITY,
TABLELOCK, TIMEOUT, and RESET. This
statement is executable only when you use it
dynamically with PREPARE and EXECUTE
or with EXECUTE IMMEDIATE. This
statement affects only dynamic statements
are that prepared after the execution of this
statement.
SET TABLE TIMEOUT* Sets a dynamic value for a lock timeout or a
stream timeout in the environment of the
current session.
LOCK TABLE* Locks a table or underlying tables of a view
and associated indexes.
UNLOCK TABLE * Releases locks held on nonaudited tables
and views.
Table 2-4. Executable SQL Statements (page4of5)
Statement Description
* Indicates the statement is an SQL/MX extension.