Data Set Options for Relational Databases

KEYSET_SIZE= Data Set Option

Specifies the number of rows in the cursor that the keyset drives.

Default value:	LIBNAME setting
Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support:	Microsoft SQL Server, ODBC

Syntax
Syntax Description
Details
See Also

Syntax

KEYSET_SIZE=number-of-rows

Syntax Description

number-of-rows: is a positive integer from 0 through the number of rows in the cursor.

Details

This option is valid only when CURSOR_TYPE=KEYSET_DRIVEN.

If KEYSET_SIZE=0, then the entire cursor is keyset-driven. If a value greater than 0 is specified for KEYSET_SIZE=, then the value chosen indicates the number of rows, within the cursor, that function as a keyset-driven cursor. When you scroll beyond the bounds that KEYSET_SIZE= specifies, the cursor becomes dynamic and new rows might be included in the cursor. This results in a new keyset, where the cursor functions as a keyset-driven cursor again. Whenever the value specified is between 1 and the number of rows in the cursor, the cursor is considered to be a mixed cursor. Part of the cursor functions as a keyset-driven cursor, and another part of the cursor functions as a dynamic cursor.