Sample host-variable declarations

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;