SQL Programming Manual for Pascal

NonStop SQL Statements and Directives
HP NonStop SQL Programming Manual for Pascal—528614-001
3-4
Locating Information About SQL Statements and
Directives
Data Definition Language (DDL) Statements
Statement or
Directive Manual* Description
ALTER SQL Alters the definition of a table; changes attributes
of an index or table; alters security attributes of a
catalog, index, program, table, or view; renames
a table, index, program, or view; or adds, drops,
moves, or splits a partition of a table or index.
COMMENT SQL Adds a comment to an object definition.
CREATE SQL Creates a constraint, catalog, index, table, or
view.
DROP SQL Drops a constraint, catalog, index, program, table,
or view.
HELP TEXT SQL Specifies help text for a column of a table or view.
UPDATE STATISTICS SQL Updates information about the contents of a table
and its indexes.
Data Manipulation Language (DML) Statements
Statement or
Directive Manual* Description
CLOSE SQL+Pascal Terminates a cursor.
DELETE SQL+Pascal Deletes rows from a table or view.
FETCH SQL+Pascal Retrieves a row from a cursor.
INSERT SQL+Pascal Inserts rows into a table or view.
OPEN SQL+Pascal Opens a cursor.
SELECT SQL+Pascal Retrieves data from tables and views.
UPDATE SQL+Pascal Updates values in columns of a table or view.
Dynamic SQL Statements
Statement or
Directive Manual* Description
DECLARE CURSOR SQL+Pascal Defines a cursor.
DESCRIBE SQL+Pascal Returns information about output variables in
prepared statements.
DESCRIBE INPUT SQL+Pascal Returns information about input variables in
prepared statements.
EXECUTE SQL+Pascal Executes a compiled statement.
EXECUTE
IMMEDIATE
SQL+Pascal Executes an SQL statement contained in a host
variable.
PREPARE SQL+Pascal Compiles a DDL, DML, or DCL statement.
Table 3-1. Summary of NonStop SQL Statements and Directives (page 2 of 4)