cancel
Showing results for 
Search instead for 
Did you mean: 

Is the PowerBuilder sqlca.Lock property supported?

553

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.

Accepted Solutions (1)

Accepted Solutions (1)

chris_keating
Product and Topic Expert
Product and Topic Expert

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.

0 Kudos

Thanks for the explanation.

Answers (0)