Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Cool Unanswered: How to set the exclusive lock for table?

    Hihi,
    I am not vy familar with Sybase.

    Please help me how to issue the command to lock the table in exclusive mode?

    Please kindly advise.

    Million Thanks

  2. #2
    Join Date
    Dec 2002
    Posts
    104

    Re: How to set the exclusive lock for table?

    Originally posted by siuming
    Hihi,
    I am not vy familar with Sybase.

    Please help me how to issue the command to lock the table in exclusive mode?

    Please kindly advise.

    Million Thanks
    Hello,

    if u want exclusive lock while selecting then u can make use of either
    holdlock or at isolation ___ in select statement

    during the insertion in a table...lock automatically promotes to exclusive lock.

    ---Pooja
    Last edited by pooja; 09-26-03 at 05:50.

  3. #3
    Join Date
    Aug 2002
    Location
    Madrid, Spain
    Posts
    97

    Re: How to set the exclusive lock for table?

    Originally posted by siuming
    Please help me how to issue the command to lock the table in exclusive mode?
    Inside an open transaction:
    lock table MYTABLE in exclusive mode

    The lock will remain until the transaction ends by COMMIT
    or ROLLBACK

    Regards,
    Mariano Corral

Posting Permissions

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