KEYSET_SIZE=

KEYSET_SIZE=

Specifies the number of rows in the cursor that are keyset driven.

Default value: 0

Alias: KEYSET=

Syntax
Details
See Also

Syntax

KEYSET_SIZE=number-of-rows

Details

This option is valid only when CURSOR_TYPE=KEYSET_DRIVEN. See CURSOR_TYPE= for more information on KEYSET_DRIVEN cursors.

Valid values for KEYSET_SIZE= are 0 through the number of rows in the cursor. 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 will 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 may 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 since part of the cursor behaves as a keyset driven cursor and part of the cursor behaves as a dynamic cursor.

By default, KEYSET_SIZE=0.

See Also

CURSOR_TYPE=

Chapter Contents
Previous
Next
Top of Page