SQL/MX Programming Manual for Java

SQLJ Syntax
HP NonStop SQL/MX Programming Manual for Java—523726-003
A-10
Supported SQL Statements
CREATE VIEW statement Creates an SQL/MX view. See Data Definition
Language (DDL)
Statements on
page 4-32.
DECLARE CATALOG statement Sets the default catalog for
unqualified schema names in
static SQL statements.
See DECLARE and
SET Statements for
Object Name
Qualification on
page 4-16.
DECLARE MPLOC statement Sets the default volume and
subvolume for unqualified
Guardian physical names of
SQL/MP objects in static SQL
statements.
See DECLARE and
SET Statements for
Object Name
Qualification on
page 4-16.
DECLARE NAMETYPE
statement
Sets the default NAMETYPE
attribute value to ANSI (logical)
or NSK (Guardian physical) for
SQL/MP objects in static SQL
statements.
See DECLARE and
SET Statements for
Object Name
Qualification on
page 4-16.
DECLARE SCHEMA statement Sets the default schema (and
optionally, the catalog) for
unqualified object names in
static SQL statements.
See DECLARE and
SET Statements for
Object Name
Qualification on
page 4-16.
DELETE statement and
positioned DELETE statement
Deletes rows from a table or
view. A positioned DELETE
statement with the WHERE
CURRENT OF clause is used
in a data retrieval loop for an
iterator.
See Example—
DELETE Statement
on page 3-28.
For a positioned
DELETE statement,
see Positioned
UPDATE and
DELETE Statements
on page 3-55
DROP CATALOG statement Deletes an empty user catalog. See Data Definition
Language (DDL)
Statements on
page 4-32.
DROP INDEX statement Deletes an SQL/MX index. See Data Definition
Language (DDL)
Statements on
page 4-32.
Table A-1. Embedded SQL/MX Statements (page 3 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