hold cursors
Prevent cursors from being closed across database commits.
USYS$INF_PARAMS hold cursors
Description
The hold cursors option is used for select statements
that are involved in building hitlists.
When this option is set, cursors and statements will not be released at
commit or rollback time. Thus, the connector is able to complete
a hitlist after a commit, if requested. If Uniface does not request the hitlist to
finish, the associated hold cursor will never be released unless a table close is
requested and all cursors and statements are released.
To force Uniface to finish a hitlist, use the following ProcScript statement:
setocc "entity", -1
If this option is not present, cursors and statements are released at
commit or rollback time.
