I'd research DFSORT JOINKEYS.
Cheers, Martin Sent from my iPad > On 17 May 2016, at 08:13, Ravi Gaur <[email protected]> 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 ... > > 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 record should be created in FILE3. > > Thanks, Ravi > > ---------------------------------------------------------------------- > 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
