Fetch-Set Statements (for scrollable cursors)

The fetch-set statement sets the row position to a randomly selected position within the set of rows actually fetched by fetch-next or fetch-last statements. The cursor used in the fetch-set statement must be declared in the same transaction as a scrollable cursor (result set cursorname).

Fetch-set statements are only applicable to cursors that have previously executed fetch-next or fetch-all statements.

Syntax

Stat = "fetch" ident "set" [ Expr ] ["unique" ].