Determines whether server-side cursors are enabled for the data source. This option applies to Forward Only, Static and Keyset cursors.
Valid Values
0 | 1 | 2 | 3 | 4
Behavior
If set to 0 (Disabled), all server-side cursors are disabled for the data source.
If set to 1 (Enable All Except Forward Only), all server-side scrollable cursors are enabled for the data source, while forward-only cursors on the server side are disabled.
If set to 2 (Enable Forward Only for Rowset Size >1), only forward-only cursors on the server-side are enabled when the rowset size is set to a value greater than one.
If set to 3 (Enable All), all server-side cursors, scrollable and forward-only, are enabled for the data source.
If set to 4 (Enable Forward Only for Select For Update), forward-only cursors on the server-side are enabled only for Select For Update statements. For other Select statements, the driver uses forward-only cursors on the client-side. This setting avoids using driver emulation for other Select statements, thereby improving performance and allowing the use of native updatable result sets.
This connection option can affect performance.