Chapter Contents

Previous

Next

CURSOR_TYPE=

Default value:	Not set
Alias:	CURSOR=
Option type:	LIBNAME and Data Set

Details

When your data source is a relational DBMS, not all database drivers support all cursor types. An error is returned if the specified cursor type is not supported.

If CURSOR_TYPE=DYNAMIC, then the cursor reflects all of the changes that are made to the rows in a result set as you scroll around the cursor. The data values and the membership of rows in the cursor can change dynamically on each fetch. The OLE DB properties that are applied to an open row set are DBPROP_OTHERINSERT=TRUE and DBPROP_OTHERUPDATEDELETE=TRUE.

If CURSOR_TYPE=KEYSET_DRIVEN, then the cursor determines which rows belong to the result set when the cursor is opened. However, changes that are made to these rows will be reflected as you scroll around the cursor. The OLE DB properties that are applied to an open row set are DBPROP_OTHERINSERT=FALSE and DBPROP_OTHERUPDATEDELET=TRUE.

If CURSOR_TYPE=STATIC, then 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 will be reflected in the cursor. Static cursors are read-only. The OLE DB properties that are applied to an open row set are DBPROP_OTHERINSERT=FALSE and DBPROP_OTHERUPDATEDELETE=FALSE.

By default, CURSOR_TYPE= is not set and the provider will use a default. See your provider documentation for more information. See OLE DB programmer reference documentation for details about these properties.

The CURSOR_TYPE= option can be specified with the alias CURSOR.

Chapter Contents

Previous

Next

Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.