1. Jim Stahlin
  2. PowerBuilder
  3. Thursday, 21 March 2024 14:51 PM UTC

If I run this code using a datawindow the isolation doesn't seem to be changed in the datawindow calls.

Test case 1

long ll_rows, ll_test

GTrans.Lock = 'SS'
dw_order_carton_info.settransobject( GTrans )
ll_rows = dw_order_carton_info.retrieve(21586146, 1)
messagebox('debug', 'SS ll_rows '+ string(ll_rows))

// Set back to read committed
GTrans.Lock = 'RC'
dw_order_carton_info.settransobject( GTrans )
ll_rows = dw_order_carton_info.retrieve(21586146, 1)
messagebox('debug', 'RC ll_rows '+ string(ll_rows))

 

If I call the SQL that is in the datawindow inline it will change the isolation level

Test case 2

long ll_rows, ll_test

GTrans.Lock = 'SS'
dw_order_carton_info.settransobject( GTrans )
select count(*)
into :ll_test
from table
using GTrans;

messagebox('debug', 'SS ll_rows '+ string(ll_rows))

// Set back to read committed
GTrans.Lock = 'RC'
dw_order_carton_info.settransobject( GTrans )
select count(*)
into :ll_test
from table
using GTrans;

messagebox('debug', 'RC ll_rows '+ string(ll_rows))

 

Is changing the isolation levels in test case 1 supported?

 

 

John Fauss Accepted Answer Pending Moderation
  1. Thursday, 21 March 2024 15:24 PM UTC
  2. PowerBuilder
  3. # 1

Hi, Jim -

Although it doesn't matter in this case, for future reference it is ALWAYS helpful when you ask a database-related question to include information regarding the DBMS vendor, version, and the transaction object's properties you use to connect with.

In regards to your question, in the PB Help topic named "Lock (database preference)" is the following critical information:

Best regards, John

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.