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.
This topic has been locked.
Pinned topic Table Locators in store procedure
2013-09-24T10:20:52Z | db2 dbdsupport
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Azhar480 270006P7A52 Posts
Re: Table Locators in store procedure2013-09-24T10:25:12ZThis is the accepted answer. This is the accepted answer.
I am using DB2 Express C 9.7 version. I have tried to pass parameter as TABLE LIKE table-name or view-name AS LOCATOR.