ASA SQL Reference
  SQL Statements

Declaration section [ESQL]

Description 

Use this statement to declare 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;

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 will be used as host variables. Not all C declarations are valid inside a declaration section. See Using host variables for more information.

Permissions 

None.

See also 

BEGIN statement

Standards and compatibility 

• SQL/92    Entry-level feature.

• SQL/99    Core feature.

• Sybase    Compatible with Adaptive Server Enterprise.

Example 

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