LIBNAME Statement: PC Files on Linux, UNIX, and 64-Bit Microsoft Windows |
Specifies the cursor type for read-only cursors and cursors to
update.
Valid in: |
DATA and PROC steps
|
Default value: |
none
|
Alias: |
CURSOR
|
CURSOR_TYPE=DYNAMIC|FORWARD_ONLY|KEYSET_DRIVEN|STATIC
|
- DYNAMIC
-
specifies that the cursor reflects all changes that are
made to the rows in a result set as you move the cursor. The data values and
the membership of rows in the cursor can change dynamically on each fetch.
This is the default for the DB2 UNIX, PC files, and SQL Server interfaces.
- FORWARD_ONLY
-
specifies that the cursor behaves like a DYNAMIC cursor,
except that it supports only fetching the rows sequentially.
- KEYSET_DRIVEN
-
specifies that the cursor determines which rows belong to
the result set when the cursor is opened. Note that changes that are made
to these rows are reflected as you scroll around the cursor.
- STATIC
-
specifies that the complete result set is built when the
cursor is opened. No changes that are made to the rows in the result set after
the cursor is opened are reflected in the cursor. Static cursors are read-only.
To assign this option to a
group of tables, use the CURSOR_TYPE= option
specified in LIBNAME Options.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.