>>If you can load to EXCEL - use its functions Not all functions on the mainframe can do everything. You should look at what makes sense. And if the tool you are comfortable in using, does not have the function, I would say to find one that does.
Lizette, EXCEL is limited to 1 million records. And it would take a lot of time to load it and then sort it and then eliminate the duplicates. >>Not all functions on the mainframe can do everything. You should look at what makes sense. And if the tool you are comfortable in using, does not have the function, I would say to find one that does. If the file is on mainframe, a Program/Utility should be able to handle it. Thanks, Kolusu ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
