keysetcursor
Set the cursor type to SQL_CURSOR_KEYSET_DRIVEN
to improve
performance when using the order by clause on large tables.
Values
-
on
—sets the cursor type toSQL_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 toSQL_CURSOR_FORWARD_ONLY
. Default.
Use
Applies to |
Mnemonic |
Connector Syntax |
---|---|---|
Microsoft SQL connector |
MSS |
USYS$MSS_PARAMS |
PostgreSQL connector |
PGS |
USYS$PGS_PARAMS |