Examples

Example 1: Define the host variables hv_smint (SMALLINT), hv_vchar24 (VARCHAR(24)), and hv_double (DOUBLE) in a C program.

  EXEC SQL  BEGIN DECLARE SECTION;
    static short                          hv_smint;
    static struct {
             short hv_vchar24_len;
             char  hv_vchar24_value[24];
           }                              hv_vchar24;
    static double                         hv_double;
  EXEC SQL  END DECLARE SECTION;

Example 2: Define the host variables HV-SMINT (smallint), HV-VCHAR24 (varchar(24)), and HV-DEC72 (dec(7,2)) in a COBOL program.

  WORKING-STORAGE SECTION.
        EXEC SQL BEGIN DECLARE SECTION  END-EXEC.
  01  HV-SMINT              PIC S9(4)       BINARY.
  01  HV-VCHAR24.
      49 HV-VCHAR24-LENGTH  PIC S9(4)       BINARY.
      49 HV-VCHAR24-VALUE   PIC X(24).
  01  HV-DEC72              PIC S9(5)V9(2)  PACKED-DECIMAL.
        EXEC SQL END DECLARE SECTION  END-EXEC.