Declaration section [ESQL]

Description

Declares host variables in an Embedded SQL program. Host variables are used to exchange data with the database.

Syntax

EXEC SQL BEGIN DECLARE SECTION;
... C declarations
EXEC SQL END DECLARE SECTION;

Examples

Example 1

EXEC SQL BEGIN DECLARE SECTION;
char *emp_lname, initials[5];
int dept;
EXEC SQL END DECLARE SECTION;

Usage

A declaration section is simply a section of C variable declarations surrounded by the BEGIN DECLARE SECTION and END DECLARE SECTION statements. A declaration section makes the SQL preprocessor aware of C variables that are used as host variables. Not all C declarations are valid inside a declaration section. See the chapter “Embedded SQL Programming” in the Adaptive Server Anywhere Programming Guide for more information.

Standards

Permissions

None.

See also

BEGIN... END statement