SQL/MX Programming Manual for C and COBOL (G06.24+, H06.03+)

Embedded SQL Statements

HP NonStop SQL/MX Programming Manual for C and COBOL—523627-004

2-9

Embedded SQL Declarations and Statements

Data Definition Language (DDL) Statements (continued)

ALTER TRIGGER Changes the definition of an trigger.

CREATE CATALOG * Defines a catalog.

CREATE INDEX * Creates an index based on one or more

columns in a table.

CREATE PROCEDURE Defines an existing Java method as an SPJ

in NonStop SQL/MX.

CREATE SCHEMA Defines a schema.

CREATE SQLMP ALIAS * Defines a mapping from an ANSI name to

the physical name of an SQL/MP table or

view.

CREATE TABLE Defines a persistent base table.

CREATE TRIGGER Defines a trigger.

CREATE VIEW Defines a viewed table.

DROP CATALOG * Destroys an empty catalog.

DROP INDEX * Destroys an index.

DROP PROCEDURE Removes an SPJ definition.

DROP SCHEMA Destroys a empty schema.

DROP SQLMP ALIAS * Destroys the mapping of an ANSI name to

the physical name of an SQL/MP table.

DROP TABLE Destroys a table.

DROP TRIGGER Destroys a trigger.

DROP VIEW Destroys a view.

GRANT Defines privileges.

GRANT EXECUTE * Defines execute privilege on a procedure.

to the remote node.

REVOKE Destroys privileges.

REVOKE EXECUTE * Destroys execute privileges on a procedure.

UNREGISTER CATALOG * Removes an empty catalog reference from a

node.

Table 2-4. Executable SQL Statements (page2of5)

Statement Description

* Indicates the statement is an SQL/MX extension.