Re: advantages of using embedded sql

Agreed, but that wasn't what was being commented on. This was obviously a
response to updating only specific fields. You've already pointed out
adding fields is easier in SQL, and no one disputed it,




From:
Alan Campin <alan0307d@xxxxxxxxx>
To:
"RPG programming on the IBM i / System i" <rpg400-l@xxxxxxxxxxxx>
Date:
09/08/2011 10:50 AM
Subject:
Re: advantages of using embedded sql
Sent by:
rpg400-l-bounces+broche=packagingcorp.com@xxxxxxxxxxxx



You are still locking the table format into the program. Add a new field
to
the table and your program crashes and you must recompile unless you turn
off format checking which is basically playing Russian roulette.

On Thu, Sep 8, 2011 at 9:10 AM, Luis Rodriguez <luisro58@xxxxxxxxx> wrote:

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

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