RE: Trigger Files

["Smith, Nelson" <NSmith@xxxxxxxxxxx>]

Has anyone come up with a real-world use for a field level trigger that
justifies the maintenance hassle?  I don't even like trying to keep up with
different triggers on the six record-level slots.  I use the same trigger
"shell" on all six slots, and let the internal code sort out what to do,
when.

Is there any performance difference between a trigger on a single field vs.
the whole record?  What do the buffers look like on a field level trigger?
Can any kind of program be fired or only something SQL-based?  I haven't
gotten to 5.1 yet, so I haven't had the chance to play with them yet.

> -----Original Message-----
> From: Rolf Mittag [SMTP:rm@r-m-e-d-v.de]
> Sent: Tuesday, August 28, 2001 1:49 PM
> To:   rpg400-l@midrange.com
> Subject:      Re: Trigger Files
>
> on 5.1 the SQL implementation of triggers allows
> a trigger to be fired based on colums, records or statements
>
> ---------------------------
> Dipl.Inf.(FH) Rolf P Mittag
> IBM Partner in Development
> Leipziger Str. 50
> D-69214 Eppelheim
> Fon: +49 (6221) 76 78 60
> Fax: +49 (6221) 76 80 26
> eMl: rm@r-m-e-d-v.de
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com


************************************************************************************************************************************************************************************************************
This message originates from Lincare Holdings Inc. It contains information 
which maybe confidential or privileged and is intended only for the individual 
or entity named above.
It is prohibited for anyone else to disclose, copy, distribute or use the 
contents of this message.
All personal messages express views solely of the sender, which are not to be 
attributed to Lincare Holdings Inc., and may not be copied or distributed 
without this disclaimer.
If you received this message in error, please notify us immediately at 
MailAdmin@lincare.com or (800) 284-2006.
************************************************************************************************************************************************************************************************************