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

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.