SQL Programming Manual for Pascal

NonStop SQL Statements and Directives
HP NonStop SQL Programming Manual for Pascal—528614-001
3-5
Locating Information About SQL Statements and
Directives
RELEASE SQL+Pascal Deallocates memory for a dynamic SQL
statement referred to through a host variable.
Transaction Control Statements
Statement or
Directive Manual* Description
BEGIN WORK SQL Starts a TMF transaction.
COMMIT WORK SQL Commits all database changes made during the
current TMF transaction and frees resources.
ROLLBACK WORK SQL Backs out the current TMF transaction and frees
resources.
Data Declaration Directives
Statement or
Directive Manual* Description
BEGIN DECLARE
SECTION
SQL+Pascal Designates the beginning of host variable
declarations.
DECLARE CURSOR SQL+Pascal Defines a cursor.
END DECLARE
SECTION
SQL+Pascal Designates the end of host variable declarations.
INCLUDE SQLCA SQL+Pascal
**
Declares the SQL communication area to receive
run-time status information.
INCLUDE SQLDA SQL+Pascal
**
Declares the SQL descriptor area to hold
information about input and output variables for
dynamic SQL statements.
INCLUDE SQLSA SQL+Pascal
**
Declares the SQL statistics area to receive
execution statistics on DML or PREPARE
statements.
INVOKE SQL+Pascal Generates a Pascal structure description of a
table or view.
Data Control Directives
Statement or
Directive Manual* Description
CONTROL
EXECUTOR
SQL+Pascal Specifies whether to process data using a single
executor or multiple executors working in parallel.
CONTROL QUERY SQL+Pascal Specifies whether to optimize queries for time to
return first row or for total query execution time.
CONTROL TABLE SQL+Pascal Specifies parameters that control locks on tables
and how tables are opened.
Table 3-1. Summary of NonStop SQL Statements and Directives (page 3 of 4)