Update 1 record of multiple with OVERLAY
Posted: Fri Feb 07, 2020 7:44 pm
Hi team,
I have a dataset (VB(90)) in which the records are like:
I need to update the first record with a "N" in first collumn, with a "Y" leaving all other record intact
Tried :
But this gives me as output only the updated record, in which case is the second one (correct). How can I get the whole file updated ?
Thanks GG
I have a dataset (VB(90)) in which the records are like:
- Y AAA BBB
N CCC DDD
N EEE FFF
N GGG HHH
I need to update the first record with a "N" in first collumn, with a "Y" leaving all other record intact
Tried :
OPTION COPY,STOPAFT=1,VLSHRT
RECORD TYPE=V,LENGTH=90
INCLUDE COND=(5,1,SS,EQ,C'N')
OUTFIL OVERLAY=(5:5,1,CHANGE=(1,C'N',C'Y'))
RECORD TYPE=V,LENGTH=90
INCLUDE COND=(5,1,SS,EQ,C'N')
OUTFIL OVERLAY=(5:5,1,CHANGE=(1,C'N',C'Y'))
But this gives me as output only the updated record, in which case is the second one (correct). How can I get the whole file updated ?
Thanks GG