> 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
