Hello,
I searched a lot ... maybe it is just not possible.
I 'd like to be able to do a select on a table on which another traitement is doing an update.
I do no want to be 'stopped' by the lock on the row that are beeing updated.
I do not want to select the lines that are beeing updated (It's OK to miss the rows, but it's not OK to have rows with "wrong" values).
Example
TableTest :
ID Value
1 test1
2 test2
3 test3
4 test4
begin tran
Update TableTest set Value = test0 where ID = 3
Select * from TableTest
I need the result (imediatly) from select to be :
ID Value
1 test1
2 test2
4 test4
Thank you !!
(Sybase 12.5.1)
I searched a lot ... maybe it is just not possible.
I 'd like to be able to do a select on a table on which another traitement is doing an update.
I do no want to be 'stopped' by the lock on the row that are beeing updated.
I do not want to select the lines that are beeing updated (It's OK to miss the rows, but it's not OK to have rows with "wrong" values).
Example
TableTest :
ID Value
1 test1
2 test2
3 test3
4 test4
begin tran
Update TableTest set Value = test0 where ID = 3
Select * from TableTest
I need the result (imediatly) from select to be :
ID Value
1 test1
2 test2
4 test4
Thank you !!
(Sybase 12.5.1)