on 2023 Dec 22 2:50 PM
Is the PowerBuilder sqlca.Lock property supported to set isolation level? The PowerBuilder help says that ODBC has the following values but it is up to the server to support them.
RU - Read Uncommitted
RC - Read Committed
RR - Repeatable Read
TS - Serializable Transactions
TV - Transaction Versioning
I've never tried it. I normally just set AutoCommit to True when retrieving.
Request clarification before answering.
Except for TV, the remaining isolation levels are supported. SQL Anywhere also supports Snapshot which is not exposed via the SQLCA.LOCK property. Further, this only controls the initial isolation level of the connection. For example, if SQLCA.LOCK="RR" sets the isolation level to 2. If you change the SQLCA.LOCK="RU" on a active SQLCA connection, it will not change the isolation level.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
52 | |
10 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.