Re: advantages of using embedded sql

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Åke,

> You can update one field only w/o touching every field in a record.
Well, that is one of the things you can do easily in RPG as well. Check the
%FIELDS keyword of the UPDATE instruction. You can write:

UPDATE record %fields(field_1:field_2...:field_n) ;

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Thu, Sep 8, 2011 at 8:47 AM, Åke Olsson <ake.olsson@xxxxxx> wrote:

> A few things:
>
> With SQL it is a lot easier to avoid record lock situations. (A SELECT does
> not lock a record).
>
> You can update one field only w/o touching every field in a record.
>
>
>
> Med vänlig hälsning / Best regards
>
> Åke H Olsson
>  --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.