Wow - that dooms Excel. I think a million lines might be the max for it Lizette
> -----Original Message----- > From: IBM Mainframe Discussion List [mailto:[email protected]] On > Behalf Of Edward Gould > Sent: Monday, July 17, 2017 9:34 PM > To: [email protected] > Subject: Re: Sort Question > > > On Jul 15, 2017, at 3:43 PM, Lizette Koehler <[email protected]> > wrote: > > > > Does this need to be a mainframe solution? > > > > How many records are involved? > > > > If not a lot of data, I load this type of data to Excel. > > > > The using the DATA tab, I then highlight the column and use the TEXT > > TO COLUMS function to break on the @ > > > > Do my sorts, then put it back together (using CONCAT function), or > > leave in excel for further filtering. > > > > Lizette > > > > Lizette, > > The user says he has about 20 million records. It is some sort of accumulated > history file. Don’t know any other details. > I gave him the IBM solution and told him to come back if he had any problems. > I was watching SDSF and a job poped up with his ID, so I decided to snoop a > little. He had difficulties with the sort control statements and it took him > several times to get them right. > When his job finally got going, there were 25 million records. > I am waiting too hear if the output was in the desired format. > > Ed ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
