Or, less kindly, learnt DFSORT / ICETOOL. It's a very useful utility and pervasive (if one counts Syncsort as the overlap in syntax and semantics approaches 100%).
It's really not that difficult. Cheers, Martin Sent from my iPad > On 17 May 2016, at 11:51, Elardus Engelbrecht <[email protected]> wrote: > > Ravi Gaur wrote: > >> Since I am not that good on Sort programming could somebody throw a code which could help in Merging two files which has common BY variable..(I generally do it with SAS) however where this required it's not licensed....so it's possible via rexx however for millions of records that's damn slow...so believe DFSORT can easily achieve it with SPLICE ... > > Or as Martin kindly said, use JOINKEYS > >> So here's what I have in two files.. > >> FILE 1 Contain variables like DSNAME VOLSER >> FILE2 Contain variables like DSNAME VOLSER > >> Now my requirement is based on VOLSER MATCH between file1 and file2 the output recor should be created in FILE3. > > I'm not sure what you want, please supply sample input and sample outputs. Also give the keys in what columns. > > Groete / Greetings > Elardus Engelbrecht > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN >Unless stated otherwise above: IBM United Kingdom Limited - Registered in England and Wales with number 741598. Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
