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.

asked 22 Dec '23, 14:50

topwiz's gravatar image

topwiz
31127
accept rate: 0%

edited 22 Dec '23, 14:51


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.

permanent link

answered 29 Dec '23, 18:13

Chris%20Keating's gravatar image

Chris Keating
7.7k49127
accept rate: 32%

Thanks for the explanation.

(29 Dec '23, 22:40) topwiz
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×13

question asked: 22 Dec '23, 14:50

question was seen: 205 times

last updated: 29 Dec '23, 22:40