• 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 |

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.

Updated on 2016-03-31T12:34:23Z at 2016-03-31T12:34:23Z by vlosa