Midrange News for the IBM i Community


Posted by: Chris Proctor
Programmer Analyst
Columbia Sports Company
Portland, OR
Stored Procedure not firing off a trigger pgm?
has no ratings.
Published: 13 Jan 2012
Revised: 23 Jan 2013 - 2185 days ago
Last viewed on: 15 Jan 2019 (5648 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

Stored Procedure not firing off a trigger pgm? Published by: Chris Proctor on 13 Jan 2012 view comments(19)

Happy Friday, everyone. I'm working on a process where I have a trigger program specified (*UPDATE *AFTER) on a physical file and a stored procedure that updates that file. If I update a record while signed on via VIEW or SQL, the trigger program fires off. If I run the stored procedure via Navigator, the record gets updated, but the trigger program is not called. 

Has anyone run into this issue before? It's obvious that the record is updated. Any help would be appreciated!

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS