Programming Guide

CONTINUE_BOTTOM

Fetches the last page of rows associated with the default or named SELECT cursor

Synopsis

DBMS [ WITH CURSOR cursor ] CONTINUE_BOTTOM

Arguments

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

Description

DBMS CONTINUE_BOTTOM fetches the last screen-full of rows from the cursor's select set. If the number of rows in the select set is less than the number of occurrences in the Prolifics variables, the request is ignored.

Some database engines automatically support DBMS CONTINUE_BOTTOM. Other engines require a temporary storage file created by the command DBMS STORE FILE. If the DM_BAD_CMD error returns when the application executes DBMS CONTINUE_BOTTOM, the engine needs a scrolling file. For information about a specific engine, refer to "Database Drivers."

DBMS CONTINUE_BOTTOM should not be used with a CATQUERY TO FILE cursor.

Example

// Engines not requiring STORE FILE.
 
proc select_all
DBMS DECLARE t_cursor FOR SELECT * FROM titles
DBMS WITH CURSOR t_cursor EXECUTE
return
 
proc get_last
DBMS WITH CURSOR t_cursor CONTINUE_BOTTOM
return
 
// Engines requiring STORE FILE.
 
proc select_all
DBMS DECLARE t_cursor FOR SELECT * FROM titles
DBMS WITH CURSOR t_cursor STORE FILE
DBMS WITH CURSOR t_cursor EXECUTE
return
 
proc get_last
DBMS WITH CURSOR t_cursor CONTINUE_BOTTOM
return

See Also

DBMS CONTINUE, DBMS CONTINUE_DOWN, DBMS CONTINUE_TOP, DBMS CONTINUE_UP, DBMS STORE