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.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.