Fetches the next set of rows associated with a default or named
DBMS [WITH CURSOR
- Name of declared
SELECTcursor. If the clause is not used, Panther uses the default
SELECTstatement retrieves more rows than can fit in its destination variables, Panther returns as many rows as will fit. It continues fetching more rows from the select set when the application executes this command. If there are pending rows, executing
CONTINUEclears the destination variables, and fetches the next screen-full of rows from the select set. If there are no pending rows, executing
If the cursor's aliases have changed between the execution of the
SELECTand the execution of
CONTINUEuses the new settings.
CONTINUEshould not be used with a
CATQUERY TO FILEcursor.
CATQUERY TO FILEalways writes out the entire select set to the
// This procedure fetches the specified rows
// and calls the JPL procedure check_count.proc get_selection
DBMS DECLARE movie_list CURSOR FOR \
SELECT * FROM titles WHERE genre_code = ::genre_code
DBMS WITH CURSOR movie_list EXECUTE USING genre_code
return// This procedure sets the message line according
// to the number of rows available.proc check_count
if @dmretcode != DM_NO_MORE_ROWS
msg setbkstat "Press %KPF1 to see more films " \
"or press %KPF2 to specify another type."else
msg setbkstat "That's all folks!"
return// This procedure is called by pressing PF1.
// It retrieves the next set of rows.proc get_more
DBMS WITH CURSOR movie_list CONTINUE