Re: DFSORT to insert missing values

2018-10-30 Thread Gil Cardenas
Thank you both for the responses and samples. I was making it too complicated and tried all kinds of parameters but keeping it simple worked like a charm. Appreciate it, Gil. -- For IBM-MAIN subscribe / signoff / archive

Re: DFSORT to insert missing values

2018-10-30 Thread Gil Cardenas
Thanks Sri, will give try this out today. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: DFSORT to insert missing values

2018-10-30 Thread Gil Cardenas
Thanks, looks like exactly like what I needed. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: DFSORT to insert missing values

2018-10-30 Thread Sri h Kolusu
Gil Cardenas, It is quite simple with DFSORT to push the contents to the next records. Using WHEN=GROUP you can push anything you want. Here is an UNTESTED example . I assumed the REPORT01,REPORT02 values start at position 1 and the values CART records have spaces in the first 4 bytes. I

Re: DFSORT to insert missing values

2018-10-29 Thread retired mainframer
AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: DFSORT to insert missing values > > Sorry for the long winded explanation but need to set the context of the > issue. > > Background: > I have a print file (LRECL=133, RECFM=FBA) that I am working with that > contains > re

DFSORT to insert missing values

2018-10-29 Thread Gil Cardenas
Sorry for the long winded explanation but need to set the context of the issue. Background: I have a print file (LRECL=133, RECFM=FBA) that I am working with that contains report data and is a rather large file 2,000 cylinders. I need to extract some statistics from the file but the format