Previous Topic Next topic Print topic


ISOLATION-LEVEL

Controls the way in which locks are acquired and released by the system.
Restriction: This topic applies to Windows environments only.

Syntax:

ISOLATION-LEVEL=[CS][ALL][RR][CHANGE][NC]

Parameters:

CS The execution of SQL statements in the package and the current row in which the database cursor is positioned are protected from the actions of concurrent users for changes the requester makes.
ALL The execution of SQL statements in the package is protected from the actions of concurrent users for rows the requester reads and changes.
RR The execution of SQL statements in the package and the current row in which the database cursor is positioned are protected from the actions of concurrent users for rows the requester reads and changes, as well as phantom rows.
CHANGE The execution of SQL statements in the package is protected from the actions of concurrent users for changes the requester makes.
NC Commitment control is not used. COMMIT and ROLLBACK statements are not required for changes to be visible to concurrent users.

Properties:

Default: CS

Comments:

This option only has meaning when program has been statically bound.

Previous Topic Next topic Print topic