• 1 reply
  • Latest Post - ‏2012-04-13T16:38:45Z by nivanov1
708 Posts

Pinned topic Autonomous Transactions

‏2012-04-11T10:55:02Z |
Dear Forum Colleagues,
I'm now extracting the DDL by using IDMT. I got "failed" in extracting an Oracle function that contains the directive PRAGMA AUTONOMOUS TRANSACTION. I know that DB2 9.7 does support the Autonomous Transactions as well, and that DB2 understands such a PL/SQL directive (as written in the Red Book <Oracle to DB2 Conversion Guide: Compatibility Made Easy>. Therefore my question is: could anyone please explain to me how to setup IDMT in order to import the object and adjust the syntax ?
Updated on 2012-04-13T16:38:45Z at 2012-04-13T16:38:45Z by nivanov1
  • nivanov1
    22 Posts

    Re: Autonomous Transactions

    You'll need to replace the PRAGMA with the AUTONOMOUS clause of the CREATE PROCEDURE statement. I doubt that IDMT can do it automatically, so it's up to you to make the change. Check this example: