SQL/MX Programming Manual for C and COBOL (G06.24+, H06.03+)

Simple and Compound Statements
HP NonStop SQL/MX Programming Manual for C and COBOL—523627-004
5-4
INSERT Statement
EXEC SQL END DECLARE SECTION;
...
EXEC SQL
SELECT projcode, projdesc, start_date
INTO :hv_projcode, :hv_projdesc, :hv_start_date
FROM samdbcat.persnl.project
WHERE projcode = 1000;
...
Nonstandard SQL/MP DATETIME Example
This example uses a typical context for selecting a nonstandard date-time value,
DATETIME MONTH TO DAY:
EXEC SQL BEGIN DECLARE SECTION;
char SQLSTATE[6];
unsigned NUMERIC (4) hv_projcode;
char hv_projdesc[19];
char hv_start_date[6];
EXEC SQL END DECLARE SECTION;
...
EXEC SQL
SELECT projcode, projdesc, CAST(start_date AS CHAR(5))
INTO :hv_projcode, :hv_projdesc, :hv_start_date
FROM samdbcat.persnl.project
WHERE projcode = 1000;
...
Interval Example
This example uses a typical context for selecting an interval value:
EXEC SQL BEGIN DECLARE SECTION END-EXEC.
01 sqlstate pic x(5).
01 hv-projcode pic 9(4) COMP.
01 hv-projdesc pic x(18).
01 hv-est-complete INTERVAL DAY(4).
EXEC SQL END DECLARE SECTION END-EXEC.
...
PROCEDURE DIVISION.
...
EXEC SQL
SELECT projcode, projdesc, est_complete
INTO :hv-projcode, :hv-projdesc, :hv-est-complete
FROM samdbcat.persnl.project
WHERE projcode = 1000
END-EXEC.
...
INSERT Statement
The INSERT statement inserts one or more rows into a table. To insert data, a
program moves the new values to a series of host variables and then executes an
C
COBOL