SQL/MX Programming Manual for Java

SQLJ Syntax
HP NonStop SQL/MX Programming Manual for Java—523726-003
A-8
Supported SQL Statements
Supported SQL Statements
These SQL/MX statements are allowed in SQLJ executable clauses. For the syntax of
these statements, see the SQL/MX Reference Manual.
You cannot embed SQL/MP statements in an SQLJ program. However, you can use
SQL/MX statements to query SQL/MP database objects. For more information, see
Name Resolution on page 4-20.
If the portability of an SQLJ program is important, avoid embedding statements that are
SQL/MX extensions to the ANSI standard. See the ANSI icon next to statements that
comply with the ANSI standard.
Table A-1. Embedded SQL/MX Statements (page 1 of 7)
SQL Statement Description More Information
ALTER INDEX statement Modifies an SQL/MX index by
changing one or more file
attributes of the index.
See Data Definition
Language (DDL)
Statements on
page 4-32.
ALTER SQLMP ALIAS statement Changes the Guardian physical
name of an SQL/MP table or
view to which an existing alias
is mapped.
See Data Definition
Language (DDL)
Statements on
page 4-32.
ALTER TABLE statement Modifies an SQL/MX table by
adding a column to the table, by
adding or dropping a constraint
on the table, or by changing
one or more file attributes of the
table.
See Data Definition
Language (DDL)
Statements on
page 4-32.
ALTER TRIGGER statement Enables or disables a trigger
individually or by the table.
See Data Definition
Language (DDL)
Statements on
page 4-32.
BEGIN WORK statement Explicitly starts a transaction. See Transaction
Management on
page 4-41.
CALL statement Invokes a stored procedure in
Java (SPJ) in SQL/MX.
See Calling Stored
Procedures in Java
on page 3-59.
COMMIT WORK statement Commits all changes made to
the database during the current
transaction and frees any
resources.
See Transaction
Management on
page 4-41.
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