The following figure shows an example of how to use the
EXEC SQL syntax to declare host variables. Figure 1: Declaring host variables with
the EXEC SQL syntax
EXEC SQL BEGIN DECLARE SECTION;
char *hostvar; /* pointer to a character */
int hostint; /* integer */
double hostdbl; /* double */
char hostarr[80]; /* character array */
struct {
int svar1;
int svar2;
⋮
} hoststruct; /* structure */
EXEC SQL END DECLARE SECTION;
The following figure shows an example of how to use the
dollar sign ($) notation to declare host variables. Figure 2: Declaring host variables with
the dollar sign ($) notation
$char *hostvar;
$int hostint;
$double hostdbl;
$char hostarr[80];
$struct {
int svar1;
int svar2;
⋮
} hoststruct;