The LIBNAME Statement for Relational Databases

KEYSET_SIZE= LIBNAME Option

Specifies the number of rows that are driven by the keyset.

Default value:	0
Valid in:	SAS/ACCESS LIBNAME statement and some DBMS-specific connection options. See the DBMS-specific reference section for details.
DBMS support:	Microsoft SQL Server, ODBC

Syntax
Syntax Description
Details
See Also

Syntax

KEYSET_SIZE=number-of-rows

Syntax Description

number-of-rows: is an integer with a value between 0 and 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 you specify a value greater than 0 for KEYSET_SIZE=, the chosen value indicates the number of rows within the cursor that functions as a keyset-driven cursor. When you scroll beyond the bounds that are specified by KEYSET_SIZE=, the cursor becomes dynamic and new rows might be included in the cursor. This becomes the new keyset and the cursor functions as a keyset-driven cursor again. Whenever the value that you specify is between 1 and the number of rows in the cursor, the cursor is considered to be a mixed cursor because part of the cursor functions as a keyset-driven cursor and part of the cursor functions as a dynamic cursor.