SQL Reference Guide > SQL Reference Guide > SQL Statements > BEGIN DECLARE
Was this helpful?
BEGIN DECLARE
Valid in: ESQL
The BEGIN DECLARE statement begins a program section that declares host language variables to embedded SQL.
The BEGIN DECLARE statement has the following format:
EXEC SQL BEGIN DECLARE SECTION
All variables used in embedded SQL statements must be declared. A single program can have multiple declaration sections.
The statements that can appear inside a declaration section are:
• Legal host language variable declarations
• An INCLUDE statement that includes a file containing host language variable declarations. (This must be an SQL INCLUDE statement, not a host language include statement.)
• A DECLARE TABLE statement (normally generated by dclgen in an included file)
The END DECLARE section statement marks the end of the declaration section.
Permissions
This statement is available to all users.
Related Statements
DECLARE TABLE
END DECLARE SECTION
INCLUDE
Last modified date: 08/29/2024