CURSOR_TYPE

Specifies the cursor type for read-only cursors and for cursors to be updated.
Valid in: DATA and PROC steps (when accessing PC files data using SAS/ACCESS software)
Default: LIBNAME option setting

Syntax

CURSOR_TYPE=KEYSET_DRIVEN | STATIC

Syntax Description

KEYSET_DRIVEN
specifies that the cursor determines which rows belong to the result set when the cursor is opened. However, changes that are made to these rows are reflected as you move the cursor.
STATIC
specifies that the cursor builds the complete result set when the cursor is opened. No changes made to the rows in the result set after the cursor is opened are reflected in the cursor. Static cursors are read-only.

Details

By default, this option is not set, and the Microsoft Jet provider uses a default. The OLE DB properties applied to an open row set are as follows:
OLE DB Properties Applied to an Open Row Set
CURSOR_TYPE
OLE DB Properties Applied
KEYSET_DRIVEN
DBPROP_OTHERINSERT=FALSE, DBPROP_OTHERUPDATEDELETE=TRUE
STATIC
DBPROP_OTHERINSERT=FALSE, DBPROP_OTHERUPDATEDELETE=FALSE
See your OLE DB programmer reference documentation for details about these properties.

See Also

To assign this option to a group of tables, use the CURSOR_TYPE option specified in LIBNAME Options.