LIBNAME Statement: PC Files on Microsoft Windows

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 value:	LIBNAME option setting

Syntax

CURSOR_TYPE=KEYSET_DRIVEN|STATIC

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.

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.