SQL/MX Programming Manual for Java

SQLJ Syntax
HP NonStop SQL/MX Programming Manual for Java—523726-003
A-9
Supported SQL Statements
CONTROL QUERY DEFAULT
statement
Overrides the system-level
default settings for the
associated connection context.
See CONTROL
Statements on
page 4-6.
CONTROL QUERY SHAPE
statement
Forces execution plans by
modifying the operator tree for
a prepared statement.
See CONTROL
Statements on
page 4-6.
CONTROL TABLE statement Specifies a performance-related
option for DML operations on a
table or view.
See CONTROL
Statements on
page 4-6.
CREATE CATALOG statement Creates an SQL/MX user
catalog.
See Data Definition
Language (DDL)
Statements on
page 4-32.
CREATE INDEX statement Creates an index based on one
or more columns of an SQL/MX
table.
See Data Definition
Language (DDL)
Statements on
page 4-32.
CREATE PROCEDURE
statement
Registers an existing Java
method as a stored procedure
in Java (SPJ) within SQL/MX.
See Data Definition
Language (DDL)
Statements on
page 4-32.
CREATE SCHEMA statement Creates an SQL/MX user
schema.
See Data Definition
Language (DDL)
Statements on
page 4-32.
CREATE SQLMP ALIAS
statement
Defines mappings from an
ANSI logical name to the
Guardian physical name of an
SQL/MP table or view.
See Data Definition
Language (DDL)
Statements on
page 4-32.
CREATE TABLE statement Creates an SQL/MX user table. See Data Definition
Language (DDL)
Statements on
page 4-32.
CREATE TRIGGER statement Creates a trigger, a mechanism
that causes the database
system to perform certain
actions automatically in
response to certain events.
See Data Definition
Language (DDL)
Statements on
page 4-32.
Table A-1. Embedded SQL/MX Statements (page 2 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