Hi all ,
I need to write a stored procedure which will be called when an after insert trigger fires.The Parameters for the SP called would be transition tables.Can anyone help me out in how to define transition tables as parameters in the stored Procedure and how to use them in the Body of the Stored Procedure.I am using Db2 v8 on Z/OS. Any help in the form of sample code or suggestions would be greatly appreciated.The language used id SQl
Thanks in Advance
Phani Kumar PV
|