DBMS Statements and Commands - CONTINUE

Programming Guide

Fetches the next set of rows associated with the default or named SELECT cursor

DBMS [ WITH CURSOR cursor ] CONTINUE_DOWN

WITH CURSOR cursor
Name of declared SELECT cursor. If the clause is not used, Prolifics uses the default SELECT cursor.

DBMS CONTINUE_DOWN is identical to DBMS CONTINUE.

// This procedure selects the rows from the table.

proc select_all
DBMS DECLARE t_cursor FOR SELECT * FROM titles
DBMS WITH CURSOR t_cursor EXECUTE
return

// This procedure fetches the next set of rows.

proc get_more
DBMS WITH CURSOR t_cursor CONTINUE_DOWN
return