IBM Mainframe Forum

by **golemis** » 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 :

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

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

by **golemis** » Fri Feb 07, 2020 8:01 pm

Tried 3 different sort steps, one for all Y, then the overlayed, and then the remaining N's, and the idea is to concatenate them at the end. However for the remaining N's, there is no STARTAFT=2 in the OPTION parameter. how can I skip the updated (overlayed) record, so I will not have it twice in the output ?

by **golemis** » Fri Feb 07, 2020 9:35 pm

I think I've done it:
1st sort

Select all

  OPTION COPY,VLSHRT
  RECORD TYPE=V,LENGTH=90
  OUTFIL FNAMES=SORTOUT,INCLUDE=(5,1,SS,EQ,C'Y')
  OUTFIL FNAMES=SORTO2,INCLUDE=(5,1,SS,NE,C'Y')

2nd have the SORTO2 as SORTIN:

Select all

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

and 3rd again the SORTO2 of 1st step as SORTIN

Select all

  OPTION COPY,SKIPREC=1,VLSHRT
  RECORD TYPE=V,LENGTH=90
  INCLUDE COND=(5,1,SS,EQ,C'N')

Seems to be working as expected. I would appreciate any comments on things I might have overseen, or missed.

Thanks GG

IBM Mainframe Forum

Update 1 record of multiple with OVERLAY

Update 1 record of multiple with OVERLAY

Re: Update 1 record of multiple with OVERLAY

Re: Update 1 record of multiple with OVERLAY