NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
S-74
Summary of SQL Statements
CREATE TABLE
Statement
Creates a base table
CREATE VIEW
Statement
Creates a view
DECLARE CURSOR
Statement *
Defines a cursor
DELETE Statement Deletes rows from a table or view
DESCRIBE Statement * Returns information about output variables of prepared 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
* Can be used only in program