Actually, if you run DB2 in shop at V8 or higher, then you have DFSORT. You would need to contact the person in your shop that installs system software like DFSORT.
Otherwise SYNCSORT may not support similar function as DFSORT does. I would contact SYNCSORT Vendor for guidance. Lizette <------------- Snip Thanks for the solution Frank. But unfortunately my system doesn't support DFSORT statements. I am running on: SYNCSORT FOR Z/OS 1.1CR TPF3A U.S. PATENTS: 4210961, 5117495 (C) 2002 SYNCSORT INC. Any ideas? - UnSnip -----------> ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html