Re: question on updating record with few fields changed

Define an O spec with record format name and the fields you wish to update 
as follows:

     otaplmsrr  e            chgrec
     o                       tastat
     o                       taatp1
     o                       taatp2
     o                       taatp3
     o                       tadate
     o                       tamicf
     o                       tarfdt
     o                       tareco
     o                       tarol#


in your code:

     c                   except    chgrec

that will only output the fields defined on the o-spec.
HTH, 

Ron Power
Programmer
Information Services
City Of St. John's, NL
P.O. Box 908
St. John's, NL
A1C 5M2
709-576-8132
rpower@xxxxxxxxxx
http://www.stjohns.ca/
___________________________________________________________________________
Success is going from failure to failure without a loss of enthusiasm. - 
Sir Winston Churchill




"subbarpu" <puthachinna.subbareddy@xxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
2006/01/13 03:16 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
<rpg400-l@xxxxxxxxxxxx>
cc

Subject
question on updating record with few fields changed






Hi All,
         I have made changes to few fields in the record. I want to updae
the changed fields without updating the entire record.
          how can i do it?

Thanks & Regards

Subba Reddy PCV