Re: advantages of using embedded sql

Alan,

I didn't want to appear as saying that it was a RPG advantage over SQL.
Just
saw Åke's post as two different items: The record lock part (which I did
not
address) and the part regarding to the ability of update just some fields
and not others, which is the part I wrote about.

That being said, almost all of my record processing is done nowadays with
SQL. There are still (at least for our shop) some things that can be done a
little faster with RLA but, as I said before, SQL's syntax is a big plus in
terms of explaining what one wants to do, making for better
"self-documenting" code. That, of course, in addition of the many other
advantages we have seen on this thread.

Regards,

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



On Thu, Sep 8, 2011 at 11:15 AM, Alan Campin <alan0307d@xxxxxxxxx> wrote:

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.

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