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

Embedded-Only SQL/MX Statements

HP NonStop SQL/MX Reference Manual—540440-003

3-27

Publish/Subscribe Examples of DECLARE CURSOR

Suppose that these SQL/MP tables and index (and the metadata mappings) have been

created:

CREATE TABLE $db.dbtab.tab1 (a int, b int, c int);

CREATE TABLE $db.dbtab.tab2 (a int, b int, c int);

CREATE INDEX $db.dbtab.itab1 ON tab1(b, c);

CREATE SQLMP ALIAS cat.sch.tab1 $db.dbtab.tab1;

CREATE SQLMP ALIAS cat.sch.tab2 $db.dbtab.tab2;

•

This example shows a holdable cursor:

DECLARE SCHEMA cat.sch;

EXEC SQL

DECLARE holdable_cursor CURSOR WITH HOLD FOR

SELECT * FROM (DELETE FROM STREAM(tab1)) tab1;

EXEC SQL BEGIN WORK;

EXEC SQL OPEN holdable_cursor;

for(;;) {

EXEC SQL FETCH holdable_cursor INTO :hv;

EXEC SQL COMMIT;

EXEC SQL BEGIN WORK;

}