Data Set Options for Relational Databases LOCATION= Data Set Option 195
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support:
ODBC, Microsoft SQL Server
Default value:
LIBNAME setting
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 behave as a keyset-driven cursor. When you scroll beyond the
bounds that are specified by KEYSET_SIZE=, then the cursor becomes dynamic and
new rows might be included in the cursor; this becomes the new keyset and the cursor
behaves 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, because
part of the cursor behaves as a keyset-driven cursor and part of the cursor behaves as a
dynamic cursor.
See Also
To assign this option to a group of relational DBMS tables or views, see the
LIBNAME option “KEYSET_SIZE= LIBNAME Option” on page 104.
LOCATION= Data Set Option
Enables you to further specify exactly where a table resides
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support: DB2 OS/390
Default value: LIBNAME setting
Syntax
LOCATION=location-name
