Locking Problem

garylam · #1 (**permalink**) 10-08-03, 23:19

Dear All,

How can I view the un-updated row of record without locking when someone updating the row and have not committed yet?!
I know we can set the "Dirty Read", but it will show the updated value, what I want is the un-updated value!

Thanks,
Gary Lam

peterd · #2 (**permalink**) 10-09-03, 09:51

Quote:

Originally posted by garylam
Dear All,

How can I view the un-updated row of record without locking when someone updating the row and have not committed yet?!
I know we can set the "Dirty Read", but it will show the updated value, what I want is the un-updated value!

Thanks,
Gary Lam

Informix does not support this functionality. You are thinking of somethinkg like Oracle's rollback segment.

-Peter D

gurey · #3 (**permalink**) 10-09-03, 10:10

Quote:

Originally posted by garylam
Dear All,

How can I view the un-updated row of record without locking when someone updating the row and have not committed yet?!
I know we can set the "Dirty Read", but it will show the updated value, what I want is the un-updated value!

Thanks,
Gary Lam

Hi,

I think that to prove using to trigger of update.

Gustavo.

Internet Services

Web Development

Digital Marketing

Consumer Tech