SQL Programming Manual for Pascal

NonStop SQL Statements and Directives
HP NonStop SQL Programming Manual for Pascal—528614-001
3-3
Locating Information About SQL Statements and
Directives
Use these statements and directives anywhere a Pascal data declaration can appear:
•
BEGIN DECLARE SECTION and END DECLARE SECTION directives
•
DECLARE CURSOR statement (static cursor only, global declarations only)
•
INCLUDE SQLCA, INCLUDE SQLSA, and INCLUDE SQLDA directives
•
INVOKE directive
•
CONTROL TABLE, CONTROL QUERY, and CONTROL EXECUTOR directives
Executable Statements
Use these statements and directives anywhere a Pascal executable statement can
appear:
•
Data Control Language (DCL) statements (including CONTROL directives)
•
Data Definition Language (DDL) statements
•
Data Manipulation Language (DML) statements
•
Dynamic SQL statements (including dynamic DECLARE CURSOR)
•
Transaction control statements
Locating Information About SQL Statements
and Directives
Table 3-1 summarizes the NonStop SQL statements and directives by type, identifies
the manual that documents each statement or directive, and gives a brief description of
the statement or directive.
The remainder of Section 3 describes the SQL statements and directives that have
specific considerations for using the Pascal programming language with NonStop SQL.
The syntax, general description, and guidelines for other statements and directives are
provided in the SQL/MP Reference Manual.
Table 3-1. Summary of NonStop SQL Statements and Directives (page 1 of 4)
Data Control Language (DCL) Statements
Statement or
Directive Manual* Description
LOCK TABLE SQL Locks a table or underlying tables of a view and
associated indexes.
UNLOCK TABLE SQL Releases locks held on nonaudited tables or
views.