START

Programming Guide

Specifies a starting row in a SELECT set

Synopsis

DBMS [WITH CURSOR cursor] START [int]

Arguments

WITH CURSOR cursor
Name of declared SELECT cursor. If the clause is not used, Panther uses the default SELECT cursor.
int
Number indicating the row at which to begin the fetch.

Description

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 START to 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 @dmrowcount. If int is greater than the number of rows in the select set, no rows are fetched.
The setting is turned off by executing DBMS START with 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 SELECT statements.

Example

proc discard_100
DBMS START 100
DBMS QUERY SELECT * FROM actors
if @dmrowcount == 0
	msg emsg "There are fewer than 100 rows."
DBMS START
return