keysetcursor

Set the cursor type to SQL_CURSOR_KEYSET_DRIVEN to improve performance when using the order by clause on large tables.

USYS$Mnemonic_PARAMS = keysetcursor : on | off

Values

  • on—sets the cursor type to SQL_CURSOR_KEYSET_DRIVEN.

    The set of results for this cursor is built when the cursor is created, which makes it insensitive to modifications by other processes. For reading data, this implies that the data retrieved might not be the same as the latest committed data. For updates this is not a problem, because Uniface fetches data (using a fresh cursor) before updating, to prevent lost updates.

  • off—sets the cursor type to SQL_CURSOR_FORWARD_ONLY. Default.

Use

Applies to

Mnemonic

Connector Syntax

Microsoft SQL connector

MSS

USYS$MSS_PARAMS

PostgreSQL connector

PGS

USYS$PGS_PARAMS