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.
1 reply Latest Post - 2013-09-24T10:25:12Z by Azhar480
Pinned topic Table Locators in store procedure
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Azhar480 270006P7A52 PostsACCEPTED ANSWER
Re: Table Locators in store procedure2013-09-24T10:25:12Z in response to Azhar480
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.