Re: Is Write Record Format Better Than EXCEPT?

It's best to upgrade to V5R2 and use the optional fields on the improved 
UPDATE operation with the %fields bif:
/free
   chain empno record;
   salary = salary + 2000;
   status = STATEXEMPT;
   update record %fields(salary:status);
 /end-free

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




"JJW" <rpgilejjw@xxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
09/26/2003 10:21 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
<rpg400-l@xxxxxxxxxxxx>
cc

Subject
Is Write Record Format Better Than EXCEPT?






Hello

When you're updating only one field in a file with around 100 fields is it 
more efficient to do a write to the record format?  We know this will 
write the entire record.  Or is it better to just do an EXCEPT and write 
just the one field?

Just wondering which was more efficient.

TIA!!!

John J. Walsh
IBM Certified Specialist - AS/400 RPG IV Developer
IBM Certified Specialist - AS/400 RPG IV Programmer
_______________________________________________
This is the RPG programming on the AS400 / iSeries (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.