Sybase Adaptive Server Anywhere - Declaration Section [ESQL]

Declaration section [ESQL]
486
Declaration section [ESQL]
Use this statement to declare host variables in an embedded SQL program.
Host variables are used to exchange data with the database.
EXEC SQL BEGIN DECLARE SECTION;
… C declarations
EXEC SQL END DECLARE SECTION;
None.
"BEGIN statement" on page 404
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" on page 20 of the book ASA Programming Interfaces Guide for
more information.
♦
SQL/92
♦
Sybase
EXEC SQL BEGIN DECLARE SECTION;
char *emp_lname, initials[5];
int dept;
EXEC SQL END DECLARE SECTION;
Function
Syntax
Permissions
See also
Description
Standards and
compatibility
Examples