SQL/MX 2.x Reference Manual (H06.04+)

Embedded-Only SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
3-5
COBOL Examples of ALLOCATE CURSOR
COBOL Examples of ALLOCATE CURSOR
This example uses extended cursor and statement names in the PREPARE and
ALLOCATE CURSOR statements:
...
ACCEPT in-curspec.
...
EXEC SQL PREPARE :curspec FROM :in-curspec END-EXEC.
...
EXEC SQL ALLOCATE :extcur CURSOR FOR :curspec END-EXEC.
...
Publish/Subscribe Examples of ALLOCATE CURSOR
This example uses the WITH HOLD clause with ALLOCATE CURSOR:
...
EXEC SQL
ALLOCATE :ext_hold_stmthold CURSOR WITH HOLD FOR
:szHoldableStatementName;
EXEC SQL BEGIN WORK;
EXEC SQL OPEN :ext_hold_stmthold;
for( ;; ) {
EXEC SQL FETCH :ext_hold_stmthold INTO :hv;
EXEC SQL COMMIT;
EXEC SQL BEGIN WORK;
}