Home > IT Answers > Development > Sorting out missing out
0 pts.
 Sorting out missing out
Application development, DB2 Universal Database, RPG
I have 2 files. One having 1000 records and the other 1350. I need to sort out the missing records and place them in an excel sheet. Programmatically how to acgieve this???

Software/Hardware used:
ASKED: March 11, 2007  1:14 AM
UPDATED: March 19, 2007  2:01 PM
RELATED QUESTIONS
Answer Wiki:
Here's the SQL to do the comparison and report the results: SELECT * FROM bigFile MINUS SELECT * FROM smallFile You're on your own for the MS Excel part. --- Sheldon Linker (sol@linker.com) Linker Systems, Inc. (www.linkersystems.com) 800-315-1174 (+1-949-552-1904)
Last Wiki Answer Submitted:  March 11, 2007  1:49 am  by  SheldonLinker   15 pts.
All Answer Wiki Contributors:  SheldonLinker   15 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

If this is a process that is done often (i.e. someone downloads a new version every day/week/etc. to work on the exceptions) is to create a view out of the SQL statement (I prefer exception join instead of the MINUS syntax) then on the desktop of users that need to run this, I create a new Data Transfer from AS400 icon that connects to the view and creates a BIFF8 file with the name.xls I want. Excel will open this file (when you double-click it), and depending on version may prompt about saving to a newer format when you go to save any changes.

BigKat
 7,205 pts.