SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-159
C Examples of INSERT
C Examples of INSERT
•
Execute an INSERT statement:
...
EXEC SQL INSERT INTO SALES.CUSTOMER
(CUSTNUM, CUSTNAME, STREET, CITY, STATE, POSTCODE)
VALUES (1120, 'EXPERT MAILERS', '5769 N.25TH PLACE',
'PHOENIX', 'ARIZONA', '85016');
...
•
Use host variables to insert values with an INSERT statement:
...
EXEC SQL INSERT INTO SALES.CUSTOMER
(CUSTNUM, CUSTNAME, STREET, CITY, STATE, POSTCODE)
VALUES (:hv_custnum, :hv_custname, :hv_street,
:hv_city, :hv_state, :hv_postcode);
...
•
Execute an INSERT statement that includes an ORDER BY on a column that is
used in an expression. The correlation name, MLT1, is the column that NonStop
SQL/MX uses for the ORDER BY:
INSERT INTO temp1
(SELECT (UDEC1_NUNIQ - 1) as MLT1 FROM
$SQL04.SQLDPOPS.B2PWL34)
ORDER BY MLT1;
COBOL Examples of INSERT
•
Execute an INSERT statement:
...
EXEC SQL INSERT INTO SALES.CUSTOMER
(CUSTNUM, CUSTNAME, STREET, CITY, STATE, POSTCODE)
VALUES (1120, 'EXPERT MAILERS', '5769 N.25TH PLACE',
'PHOENIX', 'ARIZONA', '85016')
END-EXEC.
...
•
Use host variables to insert values with an INSERT statement:
...
EXEC SQL INSERT INTO SALES.CUSTOMER
(CUSTNUM, CUSTNAME, STREET, CITY, STATE, POSTCODE)
VALUES (:hv-custnum, :hv-custname, :hv-street,
:hv-city, :hv-state, :hv-postcode)
END-EXEC.
...