if you're comparing CSV files, and exporting to excel, why bother with the AS400? I'd use Access, it can open a CSV file, and I think it can save query results as excel.
I'm pretty sure there's a construct to find records that are missing from either file, but, I can't think of it off the top of my head. worst case, you can union two not in statements to get the same results.
Last Wiki Answer Submitted: February 27, 2007 8:28 am by MODMOD0 pts.