CIS_ROWSET_SIZE option

Function

Set the number of rows that are returned from remote servers for each fetch.

Allowed values

Integer

Default

50

Scope

Can be set for an individual connection or the PUBLIC group. Takes effect when a new connection is made to a remote server.

Description

This option sets the ODBC FetchArraySize value when you are using ODBC to connect to a remote database server.

See also

For information on remote data access, see Chapter 16, “Accessing Remote Data” in the Sybase IQ System Administration Guide.