SQL Programming Manual for TAL

NonStop SQL Statements and Directives
HP NonStop SQL Programming Manual for TAL—527887-001
3-6
BEGIN DECLARE SECTION and END DECLARE
SECTION
BEGIN DECLARE SECTION and END DECLARE SECTION
The BEGIN DECLARE SECTION and END DECLARE SECTION directives designate
the beginning and ending of a Declare Section that contains host variable declarations.
A Declare Section is a part of a program that contains host variable declarations.
Follow these guidelines when you use the BEGIN DECLARE SECTION and END
DECLARE SECTION directives:
•
You can use any variable declared in the Declare Section as a host variable. For
more information see Section 2, Host Variables and Parameters
•
Do not put a Declare Section in a structure declaration.
INCLUDE SQLSA SQLRM+TAL= Declares the SQL statistics area to receive
execution statistics on DML or PREPARE
statements.
INVOKE SQLRM+TAL Generates a TAL structure description of a
table or view.
Data Control Directives
CONTROL EXECUTOR SQLRM+TAL Specifies whether to process data using a
single executor or multiple executors
working in parallel.
CONTROL QUERY SQLRM+TAL Specifies whether to optimize queries for
time to return first row or for total query
execution time.
CONTROL TABLE SQLRM+TAL Specifies parameters that control locks on
tables and how tables are opened.
Error Checking Directives
WHENEVER SQLRM+TAL= Generates code that checks SQL
statement execution for errors, warnings,
and no-row-found condition.
TAL Compiler Directives
SQL TAL Directs the TAL compiler to prepare for
processing SQL statements.
SQLMEM TAL Controls the placement of internal SQL
structures in run-time memory.
SYMBOLPAGES TAL Controls the size of the symbol table.
* SQLRM Described only in the SQL/MP Reference Manual
SQL/TAL Described only in this manual
SQLRM+SQL/TAL Described in both manuals =
Described in Section 6, Error and Status Processing
of this manual.
Table 3-1. Summary of NonStop SQL Statements and Directives (page 3 of 3)
Statement or Directive Manual * Description