Re: advantages of using embedded sql

A chain or read with a (n) no lock will give you record without locking or
using input. SQL can also go the other way using a with update clause. This
is the equivalent of doing a chain on an update file and then issuing an
update.

Exec SQL Define Cursor1 Cursor For
Select Field1,
Field2
From Table1
Where Field3 = 'Y'
With Update Field1;

Exec SQL Open Cursor1;

Exec SQL Update Field1
Using Cursor1;


Also concerning %Field() applies only to an update operation. If you are
doing a read with RLA you are reading in the entire record and the record
format is locked into the program and an %Field() just says which field is
moved into the buffer. The entire buffer is still written.

On Thu, Sep 8, 2011 at 8:48 AM, Bob P. Roche <BRoche@xxxxxxxxxxxxxxxxx>wrote:

I can read a record without locking it and update only the fields I want
using RPGIV without SQL. I wouldn't say either is harder to do with or
without SQL.



From:
Åke Olsson <ake.olsson@xxxxxx>
To:
"rpg400-l@xxxxxxxxxxxx" <rpg400-l@xxxxxxxxxxxx>
Date:
09/08/2011 09:29 AM
Subject:
Re: advantages of using embedded sql
Sent by:
rpg400-l-bounces@xxxxxxxxxxxx



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.