SQL_FOR_SET

Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex

Use this command during LT or GT finds to only fetch a set number of rows. An option is also available for this command to disable the local cash by passing NOCACHE at the end of the command call. Note that if the rowcount is set low, too many round-trips to the server may result, effecting performance significantly. Also, if the rowcount is set too high a large number of records can be pre-fetched and end up not being used by the application. Because of this, the default of 10 rows and a cache will be adequate for most situations.

Syntax

SQL_FOR_SET {FileNumber} MAXROWS {variable} {CACHE/NOCACHE}

Parameter

Description

FileNumber

The number of the file

variable

The maximum number of rows to retrieve

CACHE

fetched rows will be kept at the local cache

NOCACHE

fetched rows will not be kept at the local cache

Example

Open Customer

SQL_FOR_SET Customer MAXROWS 15 CACHE
find gt Customer by Index.1