Re: advantages of using embedded sql

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Correction...

A SELECT can and does lock records when it needs or is told to, but
most SELECTs are reads without lock.

READ and CHAIN also have the ability read the record without a lock...

HTH,
Charles



On Thu, Sep 8, 2011 at 9:17 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.