8. SQL Statements : BEGIN DECLARE : Description
 
Share this page                  
Description
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.