Specifies a starting row in a
DBMS [WITH CURSOR
cursor] START [
- Name of declared
SELECTcursor. If the clause is not used, Panther uses the default
- Number indicating the row at which to begin the fetch.
By default, when a select set contains more than one row, Panther fetches them sequentially beginning with the first row in the select set. Use
DBMS STARTto begin fetching at row
int. Panther fetches and discards
int- 1 rows from the select set before returning the requested rows to the application. The discarded rows do not update
intis greater than the number of rows in the select set, no rows are fetched.
The setting is turned off by executing
DBMS STARTwith no arguments. Closing a cursor also turns off the setting. If a cursor is redeclared without being closed, the cursor continues to use the setting for
DBMS START 100
DBMS QUERY SELECT * FROM actors
if @dmrowcount == 0
msg emsg "There are fewer than 100 rows."