|
At 12:46 05/23/2002, Mark Walter wrote: >Hello all, > >What are the advantages, if any, of *before *insert as compared to *after >*Insert trigger programs? Or doesn't it really matter? I am using the >trigger to write an audit record. There is no validation or business logic >going on here. The only thing I can think of is that the database insert >will complete if using a *after trigger if the trigger program were to fail >for some reason. With the before trigger, you can specify ALWREPCHG(*YES) on the trigger definition, and then make changes in the new record before the data hits the database. It's a handy way to make sure related field values are appropriate. Pete Hall pbhall@ameritech.net http://www.ameritech.net/users/pbhall/index.html
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.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 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.