Re: dfsort file split

2020-10-08 Thread Massimo Biancucci
Sorry for answering so fast (and so far from a PC) without testing it before. Mail priva di virus. www.avast.com

Re: dfsort file split

2020-10-07 Thread Ron Thomas
Thanks a lot Kolusu.. it worked like a charm :) mazimo- the solution provided did not work for me . Regards Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the

Re: dfsort file split

2020-10-07 Thread Sri h Kolusu
> Here , i want to add the header in the OUT01-05 files . is there a > way we can do in the same step. Ron, You used KEYBEGIN on 40,5 , the header record will have a Group number 1 and the detail records will have group number starting at 2. So if your input file always has a header then you nee

Re: dfsort file split

2020-10-07 Thread Massimo Biancucci
Ron, if you mean the very same header record of the file, if there's a condition that does allow you to recognize it, for instance if the header record is the only with double-blank at 651: SORT FIELDS=COPY OUTREC IFTHEN=(WHEN=GROUP,KEYBEGIN=(40,5),PUSH=(651:ID=2)) OUTFIL FNAMES=OUT01,BUILD=(

dfsort file split

2020-10-07 Thread Ron Thomas
Hello- i have a file which has a header and detail records , i want to split the file based on value and here below is the one i have coded //SPLITEXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD DSN=PYU678S.ITR1.FUTR.RTLDTA.UNLOAD,DISP=SHR //OUT01DD SYSOUT=* //OUT02DD SYSOUT=* /