SQL/MX Programming Manual for Java

SQLJ Syntax
HP NonStop SQL/MX Programming Manual for Java—523726-003
A-13
Supported SQL Statements
SET MPLOC statement Sets the default volume and
subvolume for unqualified
Guardian physical names of
SQL/MP objects in dynamic
SQL statements.
See DECLARE and
SET Statements for
Object Name
Qualification on
page 4-16.
SET NAMETYPE statement Sets the default NAMETYPE
attribute value to ANSI (logical)
or NSK (Guardian physical) for
SQL/MP objects in dynamic
SQL statements.
See DECLARE and
SET Statements for
Object Name
Qualification on
page 4-16.
SET SCHEMA statement Sets the default schema (and
optionally, the catalog) for
unqualified object names in
dynamic SQL statements.
See DECLARE and
SET Statements for
Object Name
Qualification on
page 4-16.
SET TABLE TIMEOUT
statement
Sets a dynamic value for a lock
timeout or a stream timeout in
the environment of the current
session.
See SET TABLE
TIMEOUT Statement
on page 4-11.
SET TRANSACTION statement Sets attributes for the next
transaction, such as the
isolation level.
In an SQLJ program, you
cannot set the autocommit
option, the READ ONLY or
READ WRITE access mode, or
the size of the diagnostics area.
See Transaction
Management on
page 4-41.
UNLOCK TABLE statement Releases locks held on
nonaudited tables and views.
See the SQL/MX
Reference Manual.
Table A-1. Embedded SQL/MX Statements (page 6 of 7)
SQL Statement Description More Information
The ANSI icon indicates a statement that complies with the ANSI standard. All other statements in this table are
SQL/MX extensions.
ANSI
ANSI