1. User's Guide
  2. Initialization Parameters
  3. HS_FDS_FETCH_ROWS

D.12 HS_FDS_FETCH_ROWS

HS_FDS_FETCH_ROWS initialization parameter for Oracle Database Gateway for SQL Server.

Property Description

Default Value

100

Range of Values

Any integer between 1 and 1000

Syntax

HS_FDS_FETCH_ROWS=num

HS_FDS_FETCH_ROWS specifies the fetch array size. This is the number of rows to be fetched from the non-Oracle database and to return to Oracle database at one time. This parameter will be affected by the HS_RPC_FETCH_SIZE and HS_RPC_FETCH_REBLOCKING parameters.

Parent topic: Initialization Parameters