Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Alphabetical list of database options

cis_rowset_size option

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

Allowed values

Integer

Default

50

Scope
  PUBLIC role For current user For other users
Allowed to set permanently? Yes, with SET ANY PUBLIC OPTION Yes Yes, with SET ANY PUBLIC OPTION
Allowed to set temporarily? Yes, with SET ANY PUBLIC OPTION Yes (current connection only) No
Remarks

This option takes effect when a new connection is made to a remote server.

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