RE: Simple Trigger Program

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

If you are on v5r3 and use SQL to create the trigger.

The yes...

CREATE TRIGGER mytrigger BEFORE UPDATE OF somecolumn...


Otherwise no.

However, using RPG or an pre-v5r3 version of SQL you can compare the values of 
the field in the before and after image buffers to determine if you need to run 
your procedure.  Same exact effect, just requires a little more work (code) on 
your part.


HTH,


Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Bob O.
> Sent: Tuesday, June 21, 2005 10:30 AM
> To: midrange-l@xxxxxxxxxxxx
> Subject: Simple Trigger Program
> 
> 
>    Is it possible to define a physical file trigger to fire 
> when a specific
>    field is changed, or is it only possible to detect the 
> changed record.  We
>    don't have any triggers on our files (it was like that 
> when I got here!),
>    and I finally came across a reason to use one (hence my 
> very first trigger
>    program).
> -- 
> 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.
> 
>