Declaration Section [ESQL]

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

Usage

A declaration section is 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 SQL Anywhere Server - Programming > Embedded SQL > Embedded SQL programming techniques.
Note: This reference points to SQL Anywhere documentation.

Standards

  • SQL—Vendor extension to ISO/ANSI SQL grammar.

Permissions

None

Related reference
BEGIN … END Statement