Comparing 2 files(output of sql queries)

meenakshi_forum · Active User Joined: 27 May 2008 Posts: 121 Location: India

I have to compare 2 files.

These are the output of Spufi run.

My first question is, how can i make these outputs of SPUFI into
normal flat files as they contain the column names from tables.

Second question is after i am able to get the flat files,

how i can compare them using Sort or some program,
what i have to do is, i have to compare each column of one file
with that of the other.

Both the files would be outcome of SQL query on the same table
but on different region.

Purpose is to check whether the data is consistent in both the regions
for the same table.

Thanks

dick scherrer · Posted: Wed Nov 25, 2009 10:02 am

Hello,

If you run the queries in batch, it should be no trouble to define the output as a dataset rather than sysout.

Maybe a query is not the way to get what you want. If you unload the 2 tables, you should be able to more easily compare the unloaded data.

Regardless of how you "get the data", it will help if you post some sample data from both files and how you want it compared.

meenakshi_forum · Active User Joined: 27 May 2008 Posts: 121 Location: India

Thanks.

I don't have to unload the complete table.

For some specific values of a column, i need to get all relevant records from the table, that's why i have used 'where' clause in my select query for that coulmn.

CHANDAN KAPOOR · New User Joined: 12 Apr 2008 Posts: 36 Location: NOIDA

Can't u use QMF , I think QMF can solve ur purpose . Thru QMF u can export the o/p to PS.

Thereafter u can use SUPERCE facility to compare both the PS files.

meenakshi_forum · Active User Joined: 27 May 2008 Posts: 121 Location: India

thanks

export--QMF is not giving proper results

dick scherrer · Posted: Wed Nov 25, 2009 11:43 am

meenakshi_forum · Active User Joined: 27 May 2008 Posts: 121 Location: India

I am sorry.

Actually it was checked by my collegue.

He is not available now but i have to deliver this task.

Thanks.

CHANDAN KAPOOR · New User Joined: 12 Apr 2008 Posts: 36 Location: NOIDA

Have u tried with QMF as there will se some unwanted fields at the top(10-15 lines) , You can delete them. Then the data will look fine.

karisurya · New User Joined: 02 Aug 2007 Posts: 64 Location: Bangalore

I am not sure what you are trying to do but what dick told should have definitely helped you, you can always unload data to a flat file from DB2 table. If you have DB2 File Aid its easy to select the criteria also, once the data is in flat file it should be very easy to compare as they both are in same format.
If this not help and if are still looking for help post what u r doing clearly with snapshots may be some one can help you.

dick scherrer · Posted: Wed Nov 25, 2009 9:14 pm

Hello,