Re: SQL Triggers to call an RPG Program?

Either:

1)  Use a ADDPFTRG versus a SQL Trigger
2)  Make your RPG program a stored procedure.  (See CREATE PROCEDURE).

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 





David Wright <dwright@xxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
08/07/2003 01:08 PM
Please respond to Midrange Systems Technical Discussion
 
        To:     Midrange Systems Technical Discussion 
<midrange-l@xxxxxxxxxxxx>
        cc: 
        Fax to: 
        Subject:        SQL Triggers to call an RPG Program?


Hi All,
 
I am attempting to use my first trigger on a database file on the 400, and 
have come up against a problem that the help & online searches have yet to 
shed light on...
 
After the update of a table, I want to pass a field from the updated row 
to an RPG/400 program as a parm.  In creating the trigger in OpsNav, I 
cannot get past the SQL Syntax Check because it claims it cannot find the 
program...
 
Can CALL only be used to call stored procedures in a SQL Trigger?
 
Thanks!
David
 
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.