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
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 Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by 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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.