CursorLib

Description

Specifies the cursor library to use when connecting to an ODBC data source.

Applies to

ODBC (if driver and back-end DBMS support this feature)

Syntax

CursorLib = 'value'

Parameter	Description
value	The cursor library to use when connecting to an ODBC data source. Values are: ODBC_Cur_Lib Use the ODBC Version 2.0 or higher cursor library. If_Needed Use the ODBC Version 2.0 or higher cursor library if your ODBC driver does not support cursors. Driver_Cursors (Default) Use your data source's native cursor support.

Parameter

Description

value

The cursor library to use when connecting to an ODBC data source. Values are:

ODBC_Cur_Lib Use the ODBC Version 2.0 or higher cursor library.
If_Needed Use the ODBC Version 2.0 or higher cursor library if your ODBC driver does not support cursors.
Driver_Cursors (Default) Use your data source's native cursor support.

Default

CursorLib = 'Driver_Cursors'

Examples

Example 1

To specify use of the ODBC version 2.0 or later cursor library when connecting to an ODBC data source, select Cursor Library from the Cursor Library drop-down list on the Transaction tab in the Database Profile Setup dialog box.