Programming Guide



CONTINUE_DOWN

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

Synopsis

DBMS [ WITH CURSOR cursor ] CONTINUE_DOWN

Arguments

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

Description

DBMS CONTINUE_DOWN is identical to DBMS CONTINUE.

Example

// 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

See Also

CONTINUE, CONTINUE_BOTTOM, CONTINUE_TOP, CONTINUE_UP, STORE