Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to call db2 store procedure in trigger / UDF?

Status
Not open for further replies.

hofc

Programmer
Mar 24, 2003
5
MY
Hi,

1. Any body know how to call store procedure in trigger?

2. Any body know how to call store procedure in user define function?


Thanks.

Regards,
fcho
 
1) not allowed
2) not allowed

Sorry to not be bearer of good news.

Andy
 
Thanks for the reply. Can trigger / UDF execute shell script?
 
I suggest you read the manual to see just exactly what you can do in a trigger or a udf. Look in the SQL Reference manual on CREATE TRIGGER and CREATE FUNCTION.

Andy
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top