LIBNAME Statement: PC Files on Linux, UNIX, and 64-Bit Microsoft Windows

CURSOR_TYPE

Specifies the cursor type for read-only cursors and cursors to update.

Syntax

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.