Example: SQL declare section template for FORTRAN embedded SQL applications

When you are creating an embedded SQL application in FORTRAN, there is a template that you can use to declare your host variables and data structures.

The following example is a sample SQL declare section with a host variable declared for each supported data type:

   EXEC SQL BEGIN DECLARE SECTION 
     INTEGER*2     AGE  /26/                       /* SQL type  500 */
     INTEGER*4     DEPT                           /* SQL type  496 */
     REAL*4        BONUS                          /* SQL type  480 */
     REAL*8        SALARY                         /* SQL type  480 */
     CHARACTER     MI                             /* SQL type  452 */
     CHARACTER*112 ADDRESS                        /* SQL type  452 */
     SQL TYPE IS VARCHAR (512) DESCRIPTION        /* SQL type  448 */
     SQL TYPE IS VARCHAR (32000) COMMENTS         /* SQL type  448 */
     SQL TYPE IS CLOB (1M) CHAPTER                /* SQL type  408 */
     SQL TYPE IS CLOB_LOCATOR CHAPLOC             /* SQL type  964 */
     SQL TYPE IS CLOB_FILE  CHAPFL                /* SQL type  920 */
     SQL TYPE IS BLOB (1M) VIDEO                  /* SQL type  404 */
     SQL TYPE IS BLOB_LOCATOR VIDLOC              /* SQL type  960 */
     SQL TYPE IS BLOB_FILE VIDFL                  /* SQL type  916 */
     CHARACTER*10  DATE                           /* SQL type  384 */
     CHARACTER*8   TIME                           /* SQL type  388 */
     CHARACTER*26  TIMESTAMP                      /* SQL type  392 */
     INTEGER*2     WAGE_IND                       /* SQL type  500 */
   EXEC SQL END DECLARE SECTION