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-8
Embedded SQL Declarations and Statements
Table 2-4. Executable SQL Statements (page1of5)
Statement Description
SQL Statements That Process Dynamic SQL
ALLOCATE CURSOR Allocates an SQL cursor.
DECLARE CURSOR Specifies a dynamic cursor in a host
program and associates the name of the
cursor with a query expression that specifies
the rows to be retrieved by using the cursor.
ALLOCATE DESCRIPTOR Allocates an input or output SQL descriptor
area.
DEALLOCATE DESCRIPTOR Deallocates an SQL descriptor area.
PREPARE Prepares (compiles) a dynamic SQL
statement for subsequent execution by an
EXECUTE statement.
DEALLOCATE PREPARE Deallocates a prepared statement, returns
the system resources used by the statement,
an enables reuse of the statement name.
DESCRIBE Uses an SQL descriptor area to return
descriptions of output variables (usually
SELECT columns) from a prepared
statement.
DESCRIBE INPUT Uses an SQL descriptor area to store
information on input parameters for a
prepared statement.
EXECUTE Executes a prepared dynamic SQL
statement.
EXECUTE IMMEDIATE Prepares (compiles) and executes a
dynamic SQL statement.
GET DESCRIPTOR Retrieves information from an SQL
descriptor area.
SET DESCRIPTOR Modifies information in an SQL descriptor
area.
Diagnostics Statement
GET DIAGNOSTICS Returns diagnostic information on the most
recently executed SQL statement.
Data Definition Language (DDL) Statements
ALTER INDEX * Changes the file attributes of an index.
ALTER SQLMP ALIAS * Changes the physical name of an SQL/MP
table to which an existing alias is mapped.
ALTER TABLE Changes the definition of an table.
* Indicates the statement is an SQL/MX extension.