SQL/MX Programming Manual for Java

SQLJ Syntax
HP NonStop SQL/MX Programming Manual for Java—523726-003
A-11
Supported SQL Statements
DROP PROCEDURE statement Removes a stored procedure in
Java (SPJ) from SQL/MX.
See Data Definition
Language (DDL)
Statements on
page 4-32.
DROP SCHEMA statement Deletes an empty user schema. See Data Definition
Language (DDL)
Statements on
page 4-32.
DROP SQLMP ALIAS statement Deletes mappings from ANSI
logical names to the Guardian
physical names of SQL/MP
tables or views.
See Data Definition
Language (DDL)
Statements on
page 4-32.
DROP TABLE statement Deletes an SQL/MX table, any
indexes, and any constraints on
the table except constraints for
which this table is the
referenced table in a referential
integrity constraint.
See Data Definition
Language (DDL)
Statements on
page 4-32.
DROP TRIGGER statement Deletes a trigger. See Data Definition
Language (DDL)
Statements on
page 4-32.
DROP VIEW statement Deletes an SQL/MX view. See Data Definition
Language (DDL)
Statements on
page 4-32.
FETCH statement Retrieves data for each row of a
result set for a positioned
iterator.
See Positioned
Iterator on page 3-48.
GRANT statement Grants access privileges for a
table or view to specified users.
See Data Definition
Language (DDL)
Statements on
page 4-32.
GRANT EXECUTE statement Grants execute privilege for a
stored procedure in Java (SPJ)
to specified users.
See Data Definition
Language (DDL)
Statements on
page 4-32.
INSERT statement Inserts rows into a table or
view.
See Example—
INSERT Statement on
page 3-28.
Table A-1. Embedded SQL/MX Statements (page 4 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
ANSI
ANSI
ANSI
ANSI