Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search
APPCSecurity [Table of Contents] PasswordRequired

Access Service User's Guide DirectConnect for AS/400

[-] Chapter 2 Configuring the DirectConnect Access Service Library
[-] Access service Target Interaction properties
[-] IsolationLevel

IsolationLevel

Controls commit and rollback management for objects on the AS/400 that are referenced by dynamic SQL statements.

Syntax

IsolationLevel=[ cs | ur | no ]

Default

cs

Values

cs specifies cursor stability commitment control. Journaling is required for all objects.

ur specifies uncommitted read commitment control. Journaling is required for all objects that will be referred to by dynamic SQL statements that are not select statements.

no specifies that there is no commitment control. Journaling is not required for any objects. If set to no, commits or rollbacks do not occur on any inserts or updates.

APPCSecurity [Table of Contents] PasswordRequired