Results 1 to 1 of 1
  1. #1
    Join Date
    Oct 2004
    Posts
    2

    Unanswered: What is equal to @@trancount in DB2

    Hi,
    I have a SP in SQL Server i used code like this some places, Now i was changing SP to DB2...

    IF @@error =0
    COMMIT TRANSACTION
    IF @@trancount > 0
    ROLLBACK TRANSACTION

    Can any one know how to deal this in DB2?

    Thanks!
    Last edited by globaldb2; 10-07-04 at 12:44.

Posting Permissions

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