Cursors

EXEC SQL DECLARE cursorName CURSOR FOR

SELECT …. FROM …. WHERE …. ;

EXEC SQL OPEN cursorName;

while (true) {

EXEC SQL FETCH FROM cursorName INTO :variables;

if (NO_MORE_TUPLES) break;

/* do something with values */

}

EXEC SQL CLOSE cursorName;

Previous slide

Next slide

Back to first slide

View graphic version