Hello again, After tinkering a little bit more, as I was far form satisfied with the last result, I managed to get twenty two output records:
ASCLI 830 KB 0 KB 0 KB ASCLI 8.190 KB 0 KB 0 KB ASCLI 166 KB 0 KB 0 KB ASCLI 830 KB 0 KB 0 KB ASCLI 830 KB 0 KB 0 KB ASCLI 830 KB 0 KB 0 KB ASCLI 3.320 KB 0 KB 0 KB ASCLI 332 KB 0 KB 0 KB ASCLI 830 KB 0 KB 0 KB ASCLI 830 KB 0 KB 0 KB ASCLI 0 KB 830 KB 0 KB ASCLI 0 KB 0 KB 830 KB ASCLI 0 KB 0 KB 830 KB ASCLI 0 KB 0 KB 332 KB ASCLI 0 KB 0 KB 3.320 KB ASCLI 0 KB 0 KB 8.189 KB ASCLI 0 KB 0 KB 166 KB ASCLI 0 KB 0 KB 830 KB ASCLI 0 KB 0 KB 830 KB ASCLI 0 KB 0 KB 830 KB ASCLI 0 KB 0 KB 830 KB ASCLI 0 KB 0 KB 830 KB So, now I have one output record for each input one, but if I add the SORT FIELDS=HLQ, I get three, one total for each record type: ASCLI 0 KB 830 KB 0 KB ASCLI 16.988 KB 0 KB 0 KB ASCLI 0 KB 0 KB 17.817 KB And I still cannot understand why. Best wishes Jack On Thu, 7 Sept 2023 at 15:11, Jack Zukt <[email protected]> wrote: > Hi Kolusu, > > Thank you for you help. > I used one HLQ that has few files, (10 DASD; 1 Migrated; 11 HSM Backup; 22 > DCOLLECT records). > > On my first try it gave me three output records: > ASCLI 0 KB 830 KB 0 KB > ASCLI 16.988 KB 0 KB 0 KB > ASCLI 0 KB 0 KB 17.817 KB > > on the second run, with OUTFIL INCLUDE and without SUM FIELDS, it gave me > ten records: > ASCLI 830 KB 0 KB 0 KB > ASCLI 8.190 KB 0 KB 0 KB > ASCLI 166 KB 0 KB 0 KB > ASCLI 830 KB 0 KB 0 KB > ASCLI 830 KB 0 KB 0 KB > ASCLI 830 KB 0 KB 0 KB > ASCLI 3.320 KB 0 KB 0 KB > ASCLI 332 KB 0 KB 0 KB > ASCLI 830 KB 0 KB 0 KB > ASCLI 830 KB 0 KB 0 KB > > It has the info from the ten type "D" records but there is no information > for the type "B" and type "M" records. > > Any ideas? > Jack > > > On Thu, 7 Sept 2023 at 13:14, Sri h Kolusu <[email protected]> wrote: > >> >> Now, I hope that you do not mind if I ask you for one more thing. I >> wanted to have one line with the high level qualifier and all the three >> values but instead I am getting three lines for each HLQ. >> >> Jack, >> >> If you used the updated INREC then you should have gotten a summary >> record of 1 record per HLQ. If you are still getting multiple records per >> hlq, then you still must be getting an overflow. How about we diagnose the >> issue? >> >> Pick a HLQ where you are getting multiple records and use it in the >> include on OUTFIL without SUM fields >> >> //SYSIN DD * >> OPTION VLSHRT,VLSCMP,DYNALLOC=(,4) >> INCLUDE COND=(DCURCTYP,EQ,DCUDATAT,OR, * DATA RECORD >> DCURCTYP,EQ,UKTMIGR,OR, * MIGR RECORD >> DCURCTYP,EQ,UKTBACK) * BACKUP RECORD >> >> INREC IFTHEN=(WHEN=INIT, >> PARSE=(%01=(ABSPOS=29,ENDBEFR=C'.',FIXLEN=8)), >> OVERLAY=(FMT-HLQ:%01, >> TMP-DCDALLSP:8Z, >> TMP-UMALLSP:8Z, >> TMP-UBALLSP:8Z)), >> >> IFTHEN=(WHEN=(DCURCTYP,EQ,DCUDATAT), >> OVERLAY=(TMP-DCDALLSP2:DCDALLSP)), * ALLOC SPACE >> >> IFTHEN=(WHEN=(DCURCTYP,EQ,UKTMIGR), >> OVERLAY=(TMP-UMALLSP2:UMALLSP)), * MIGRATED SPACE >> >> IFTHEN=(WHEN=NONE, >> OVERLAY=(TMP-UBALLSP2:UBALLSP)) * BACKUP SPACE >> >> SORT FIELDS=(FMT-HLQ,A) * SORT BY DATASET HLQ >> >> OUTFIL INCLUDE=(FMT-HLQ,EQ,C'JACKZUKT') >> /* >> >> >> Now check the output for the field values of all the space fields that >> you added. >> >> Thanks, >> Kolusu >> DFSORT Development >> IBM Corporation >> >> >> >> ---------------------------------------------------------------------- >> For IBM-MAIN subscribe / signoff / archive access instructions, >> send email to [email protected] with the message: INFO IBM-MAIN >> > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
