SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-75
Statements
DESCRIBE INPUT Statement * Returns information about input variables of prepared
statements
DROP Statement
Drops a catalog, collation, constraint, index, table, view,
or SQL program in a Guardian file
END DECLARE SECTION
Directive *
Ends a section in a host program for declaring variables
known to SQL
EXECUTE Statement
Executes a compiled statement
EXECUTE IMMEDIATE
Statement *
Executes an SQL statement contained in a host variable
FETCH Statement
* Retrieves a row from a cursor
FREE RESOURCES Statement
Closes cursors and releases locks held by a process
GET CATALOG OF SYSTEM
Statement
Retrieves the name of a local or remote system catalog
GET VERSION Statement
Retrieves the version of a specific SQL object, catalog,
or system
GET VERSION OF PROGRAM
Statement
Retrieves the PCV, PFV, or HOSV of an SQL program
HELP TEXT Statement
Specifies help text for a column of a table or view
INCLUDE SQLCA Directive
* Declares an area in a host program to receive run-time
status information
INCLUDE SQLDA Directive
* Declares an area in a host program to receive
information about input and output variables for dynamic
SQL statements
INCLUDE SQLSA Directive
* Declares an area in a host program to receive execution
statistics for DML statements
INCLUDE STRUCTURES
Directive *
Specifies the structure version for INCLUDE SQLCA,
INCLUDE SQLSA, and INCLUDE SQLDA directives
INSERT Statement
Inserts a row into a table or view
INVOKE Directive and
Command
Generates a record description of a table or view
LOCK TABLE Statement
Locks a table (or the underlying tables of a view) and
associated indexes
OPEN Statement
* Opens a cursor
PREPARE Statement
Compiles a DDL, DML, DCL, or DSL statement for later
execution by EXECUTE
RELEASE Statement
* Deallocates memory for a dynamic SQL statement
referred to through a host variable
Table S-3. Summary of SQL Statements
Command Action
* Can be used only in program