SQL Programming Manual for TAL

NonStop SQL Statements and Directives
HP NonStop SQL Programming Manual for TAL—527887-001
3-4
Locating Information About SQL Statements and
Directives
Locating Information About SQL Statements
and Directives
Table 3-1 summarizes the NonStop SQL statements and directives by type and the
manual that documents each statement or directive.
The remainder of this section describes the NonStop SQL statements and directives in
alphabetic order. Only the SQL, SQLMEM, and SYMBOLPAGES directive descriptions
show the complete syntax. For the syntax, general description, and guidelines for other
SQL statements and directives, see the SQL/MP Reference Manual.
Table 3-1. Summary of NonStop SQL Statements and Directives (page 1 of 3)
Statement or Directive Manual * Description
Data Control Language (DCL) Statements
FREE RESOURCES SQLRM Closes cursors and releases locks held by
the program.
LOCK TABLE SQLRM Locks a table or underlying tables of a view
and associated indexes.
UNLOCK TABLE SQLRM Releases locks held on nonaudited tables
or views.
Data Definition Language (DDL) Statements
ALTER SQLRM 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, or
moves a partition of a table or index.
COMMENT SQLRM Adds comments to an object definition.
CREATE SQLRM Creates a constraint, catalog, index, table,
or view.
DROP SQLRM Drops a constraint, catalog, index,
program, table, or view.
HELP TEXT SQLRM Specifies help text for a column of a table
or view.
UPDATE STATISTICS SQLRM Updates information about the contents of
a table and its indexes.
Data Manipulation Language (DML) Statements
CLOSE SQLRM+SQL/TAL Terminates a cursor.
DECLARE CURSOR
(static)
SQLRM+SQL/TAL Defines a cursor
DELETE SQLRM+SQL/TAL Deletes rows from a table or view.
FETCH SQLRM+SQL/TAL Retrieves a row from a cursor.