Indicates whether the Driver Manager uses the ODBC Cursor Library.
| Valid in: | SAS/ACCESS LIBNAME statement and some DBMS-specific connection options. See the DBMS-specific reference section for details. |
|---|---|
| Category: | Data Access |
| Default: | NO |
| Data source: | Aster, Microsoft SQL Server, ODBC, SAP HANA |
| See: | CURSOR_TYPE= LIBNAME option. For more information about the ODBC Cursor Library, see your vendor-specific documentation. |
Table of Contents
specifies that the Driver Manager uses the ODBC Cursor Library. The ODBC Cursor Library supports block scrollable cursors and positioned update and delete statements.
specifies that the Driver Manager uses the scrolling capabilities of the driver.
Microsoft SQL Server on UNIX: Due to updates to the Data Direct driver that are included with hot fixes J2Y006 (April 2024) and M2L006 (May 2024) and later, support for the cursor library utility is deprecated. Although using this option does not cause an error, the resulting performance might not be the same when you set USE_ODBC_CL=YES. Instead, it is recommended that you set CURSOR_TYPE=FORWARD_ONLY.