|
Sets the number of rows that are returned from remote servers for each fetch.
Integer
50
| 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 |
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.