Is the PowerBuilder sqlca.Lock property supported?

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.

isolation-level

asked 22 Dec '23, 14:50

topwiz
31●1●2●8
accept rate: 0%

edited 22 Dec '23, 14:51

flat view

One Answer:

active answers oldest answers newest answers popular answers

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 Keating
7.8k●49●128
accept rate: 32%

Thanks for the explanation.

(29 Dec '23, 22:40) topwiz

flat view

Your answer

toggle preview

community wiki:

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

learn more about Markdown

Question tags:

isolation-level ×13

question asked: 22 Dec '23, 14:50

question was seen: 244 times

last updated: 29 Dec '23, 22:40

SAP SQL Anywhere

Is the PowerBuilder sqlca.Lock property supported?

Follow this question

Related questions