Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    9

    Unanswered: Timing out transactions

    Can anyone tell me as to how I can Timeout a transaction. For example I have transactiopn that pulls in data from a remote source. So if the time of extraction exceeds sometime say 1hr..I need to rollback the transaction.

    Cannot use Set Lock_Time out because it can be used only for timing out a waiting process. Here I want to timeout the executing process

    Regards
    Manmeet

  2. #2
    Join Date
    May 2003
    Location
    UK
    Posts
    220
    Howdy,

    Put some code in the transaction with a conditional statement that will rollback the transaction if 60 minutes has gone by.

    Cheers,

    SG.

Posting Permissions

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