RE: advantages of using embedded sql

You can update one field only w/o touching every field in a record.


Isn't the following the same?

UPDATE RECORDFORMAT %fields(Field);

In that only the fields specified are updated into the Input/Output buffer.




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