| Programming Guide | |
Fetches the next set of rows associated with the default or named
SELECTcursor
DBMS [WITH CURSORcursor] CONTINUE_DOWN
WITH CURSORcursor- Name of declared
SELECTcursor. If the clause is not used, Panther uses the defaultSELECTcursor.
CONTINUE_DOWNis identical toCONTINUE.
// 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
CONTINUE,CONTINUE_BOTTOM,CONTINUE_TOP,CONTINUE_UP,STORE