Results 1 to 3 of 3

Thread: Locking Problem

  1. #1
    Join Date
    Oct 2003
    Posts
    6

    Question Unanswered: Locking Problem

    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

  2. #2
    Join Date
    Jun 2003
    Posts
    1

    Re: Locking Problem

    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

  3. #3
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780

    Re: Locking Problem

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •