OpenSQL Reference Guide > OpenSQL Reference Guide > OpenSQL 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.
Last modified date: 08/14/2024