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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Call Stored Procedure from Trigger (DB2/6000 v7.2.3)

Status
Not open for further replies.

mcelhind

Programmer
Mar 19, 2003
1
US
Having an issue with calling a stored procedure from within a trigger. From documentation and other technical sites, this functionality is available. But I'm having a hard time determining whether it is available for the platform we are using or it is syntax. Getting compilation error about CALL.


CREATE TRIGGER ....
....
BEGIN ATOMIC
CALL schema.storedproc;
END
@
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top