Re: advantages of using embedded sql

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