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;
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 Using host variables.
SQL/2003 Core feature.
EXEC SQL BEGIN DECLARE SECTION; char *surname, initials; int dept; EXEC SQL END DECLARE SECTION;
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|