SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
2-175
COBOL Examples of EXECUTE
END-EXEC.
...
EXEC SQL EXECUTE USING SQL DESCRIPTOR 'in_args'
INTO SQL DESCRIPTOR 'out_cols'
END-EXEC.
...
•
This example uses extended statement names:
...
MOVE "ins_cust1" TO stmt.
EXEC SQL PREPARE :stmt FROM :stmt-buffer END-EXEC.
EXEC SQL EXECUTE :stmt END-EXEC.
...
MOVE "ins_cust2" TO stmt.
EXEC SQL PREPARE :stmt FROM :stmt-buffer END-EXEC.
EXEC SQL EXECUTE :stmt END-EXEC.