• 1 reply
  • Latest Post - ‏2013-09-24T10:25:12Z by Azhar480
2 Posts

Pinned topic Table Locators in store procedure

‏2013-09-24T10:20:52Z | db2 dbdsupport

I want to access the data changed in store procedure. I wrote trigger on Table i.e T1 and I gets Transition table in trigger on every insert on table T1. Now I wants to pass this transition table to store proedure in db2. I tried alot but could not succeed to create a store procedure which takes transition table as arguments. Can any one explain how can we use the db2 table locators to access triggers transition table in store procedure. any help would be appreciated.