RE: SQL/400 Trigger Problem

When the trigger is fired, you are already presented with the data for that
one record only.  Just change whatever you want to change.  There is no
reason to use SQL unless your change involves going out to other files for
other data.

> -----Original Message-----
> From: Ian J. Forsyth [SMTP:iforsyth@360GROUP.com]
> Sent: Wednesday, November 14, 2001 10:17 PM
> To:   midrange-l@midrange.com
> Subject:      SQL/400 Trigger Problem
>
> Is there a way to create a RPG trigger on a physical file and embed SQL
> in the RPG code to update ONLY the record being inserted and no other?
>
> I know how to embed SQL in an RPG program, but if I do:
>
> update file x
> set field Ðvalue
>
> I believe I'm globally updating every record in the file instead of
> updating
>
> the one that's being inserted.
>
>
>
>
>
>
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.


************************************************************************************************************************************************************************************************************
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.
************************************************************************************************************************************************************************************************************