![CLOSE_ON_ENDTRANS option [TSQL]](arrow-right.gif){kind=icon}
Set the number of rows that are returned from remote servers for each fetch.
Integer
Can be set for an individual connection or the PUBLIC group. Takes effect when a new connection is made to a remote server.
50
This option sets the ODBC FetchArraySize value when using ODBC to connect to a remote database server.
For information on remote data access, see Chapter 16, “Accessing Remote Data” in the Sybase IQ System Administration Guide.
