MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » May 2014

Re: Update a field in a file from the trigger on the same file



fixed

Chuck,

Good idea using the "before update of ". A further optimization would be
using a WHEN clause before the trigger's main body. Something like:

create trigger mylib/mytrig
before update of the_specific_field /* <-- addendum */

on mylib/myfile
referencing new as new_row
for each row mode db2row
when new_row.myfield < 0
begin
set new_row.myfield = 0;
end /* FWiW: officially, there is no semicolon here */


Also, thanks for the heads-up regarding the last semicolon. Sometimes one
gets carried away with them...:-)

Best regards,
Luis




Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact