RE: SQL Triggers to call an RPG Program?

[rob@xxxxxxxxx]

Look harder.
http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/db2/rbafzmstcallsta.htm#HDRCALLSTA

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:56 PM
Please respond to Midrange Systems Technical Discussion
 
        To:     "'Midrange Systems Technical Discussion'" 
<midrange-l@xxxxxxxxxxxx>
        cc: 
        Fax to: 
        Subject:        RE: SQL Triggers to call an RPG Program?


Thanks Rob.

I looked at that, but did not see a way to pass a value from a field of 
the updated row as a parm.

Also, is there a down side to using SQL Triggers?

David


-----Original Message-----
From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx]

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 
_______________________________________________
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.