Hi Kolusu...yes, all the master files and the trans files are 90 bytes FB. Each record has multiple pieces of data, with the three master files being sorted on their respective "key". I did make one little error earlier, by forgetting that two of the files have compound keys... so here is the sort criteria once more - correctly! File1 - Sort Char 10-15 and then 40-47 File2 - Sort Char 73-81 and then 40-47 File3 - Sort Char 40-47
Thanks for your help! B On Mon, Aug 3, 2015 at 4:00 PM, Sri h Kolusu <skol...@us.ibm.com> wrote: > Bill, > > Are all Input files of the same LRECL and RECFM? If so we can accomplish > the task in a Single pass of the data and sort the accordingly. There is a > trick to get it done. Let me know the attributes of all the input file and > desired output file attributes and I will show you a way to do it. > > Thanks, > Kolusu > DFSORT Development > IBM Corporation > > IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> wrote on > 08/03/2015 12:33:46 PM: > > > From: Bill Ashton <bill00ash...@gmail.com> > > To: IBM-MAIN@LISTSERV.UA.EDU > > Date: 08/03/2015 12:34 PM > > Subject: SORT one input to 3 output files - different orders > > Sent by: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> > > > > Good afternoon, friends! I thought this should be easy, but I can't get > > started with this. > > > > I have one "transaction" file that I need to add to 3 different "master" > > files. The master files are in 3 different sequences, so I can't just > sort > > the trans file and MOD it to the end. Also, because I don't know which > day > > of this week the file will come in, I need to run this every day, and so > > need to also drop my duplicate entries, as I know the trans file is > unique. > > > > Can this be done in a single sort step? > > > > For the sake of argument, assume these sorts: > > File1 - sort Char data in cols 10-15 > > File2 - sort Char data in cols 73-81 > > File3 - sort Char data in cols 40-47 > > > > Each file, when master & trans are combined, will all have the same > data, > > just in different order. > > > > Thanks for directing me! > > Billy > > > > -- > > Thank you and best regards, > > *Billy Ashton* > > > > ---------------------------------------------------------------------- > > For IBM-MAIN subscribe / signoff / archive access instructions, > > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > > > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- Thank you and best regards, *Billy Ashton* ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
