Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    earth
    Posts
    96

    Unanswered: DB2 Select For Update NOWAIT

    Hello,

    Is there a similar parameter in db2 to pass with select for update with nowait as in oracle?

    Thank you

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Depending on the DB2 version, you can change the lock timeout value for the session dynamically, so you'd set it to 0 before the query, then reset it back to the original value.
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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