or you could load it to DB2 and use SQL to get the cartesian join (the SQL people get excited about calling a many to many merge by different names) select tab1col1, tab1col2, tab2col2 from input1 inner join input2 on tab1col2 = tab2col1. The cartesian join will match duplicate keys from either side to all matching rows on the other input.
Mike ---------------------------------------------------------------------- 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
