BEGIN DECLARE SECTION
Go Up to Statement and Function Reference (Language Reference Guide)
Identifies the start of a host-language variable declaration section. Available in gpre.
BEGIN DECLARE SECTION;
Description: BEGIN DECLARE SECTION is used in embedded SQL applications to identify the start of host-language variable declarations for variables that will be used in subsequent SQL statements. BEGIN DECLARE SECTION is also a preprocessor directive that instructs gpre to declare SQLCODE automatically for the applications programmer.
- Important:
BEGIN DECLARE SECTIONmust always appear within a module’s global variable declaration section.
Example: The following embedded SQL statements declare a section and a host-language variable:
EXEC SQL
BEGIN DECLARE SECTION;
BASED ON EMPLOYEE.SALARY salary;
EXEC SQL
END DECLARE SECTION;