RE: advantages of using embedded sql

FYI,

You can do that now with RLA too.

Update record %Fields(field1);


Of course you do have to read the record before you could update it.




-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Åke Olsson
Sent: Thursday, September 08, 2011 9:17 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: advantages of using embedded sql

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.

________________________________

Notice from Bob Evans Farms, Inc: This e-mail message, including any attachments, may contain confidential information that is intended only for the person or entity to which it is addressed. Any unauthorized review, use, disclosure or distribution is strictly prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message and any attachments.