SQL/MX Programming Manual for Java

SQLJ Syntax
HP NonStop SQL/MX Programming Manual for Java—523726-003
A-12
Supported SQL Statements
LOCK TABLE statement Locks a table or underlying
tables of a view and associated
indexes.
Note: LOCK TABLE blocks the
entire JVM process even when
the Java environment is
nonblocking (nowaited).
See the SQL/MX
Reference Manual.
MODULE Directive Specifies a module name to be
used for the module file.
See MODULE
Directive on
page 4-12.
REGISTER CATALOG statement Establishes a catalog reference
on a remote node for a catalog
that is visible on the local node.
See Data Definition
Language (DDL)
Statements on
page 4-32.
REVOKE statement Revokes access privileges for a
table or view from specified
users.
See Data Definition
Language (DDL)
Statements on
page 4-32.
REVOKE EXECUTE statement Revokes execute privilege for a
stored procedure in Java (SPJ)
from specified users.
See Data Definition
Language (DDL)
Statements on
page 4-32.
ROLLBACK WORK statement Backs out the current
transaction and frees
resources.
See Transaction
Management on
page 4-41.
SELECT statement and
SELECT INTO statement
Retrieves data from a table or
view. The SELECT INTO
statement retrieves a single row
of data from a table or view and
assigns the values to host
variables.
For a single-row
query, see Example—
SELECT INTO
Statement on
page 3-28.
For a multiple-row
query, see Iterators
and Result Sets on
page 3-48.
SET CATALOG statement Sets the default catalog for
unqualified schema names in
dynamic SQL statements.
See DECLARE and
SET Statements for
Object Name
Qualification on
page 4-16.
Table A-1. Embedded SQL/MX Statements (page 5 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
ANSI
ANSI
ANSI