Page 3 of 4

Re: File Comparison using ICETOOL

PostPosted: Fri Aug 31, 2012 1:06 pm
by NicC
If you have a one-to-one match on both files and they are both in the same order then you do not need a key.

Re: File Comparison using ICETOOL

PostPosted: Fri Aug 31, 2012 1:32 pm
by thermalchu
k :)
I'll try..

Re: File Comparison using ICETOOL

PostPosted: Fri Aug 31, 2012 1:32 pm
by BillyBoyo
Do you have duplicates on the keys, I asked. Either file.

Re: File Comparison using ICETOOL

PostPosted: Fri Aug 31, 2012 1:36 pm
by thermalchu
I was checking that. First 30 and last 30 IDs of both files are exactly matching. One file has 2 extra header lines. Still both files have same record count. I don't know why..

Re: File Comparison using ICETOOL

PostPosted: Fri Aug 31, 2012 1:46 pm
by BillyBoyo
OK, first thing, simple JOINKEYS on the keys. You have a "test" extract I assume, which contains representative data?
 JOIN UNPAIRED,F1,F2,ONLY
 REFORMAT FIELDS=(F1:f1key;F2:f2key,?)

Re: File Comparison using ICETOOL

PostPosted: Fri Aug 31, 2012 3:09 pm
by thermalchu
I'm trying, Taking time because of x-wait...

Re: File Comparison using ICETOOL

PostPosted: Fri Aug 31, 2012 3:10 pm
by thermalchu
dfsort-icetool-icegener/topic6864.html

Isn't this post similar to ours?

Re: File Comparison using ICETOOL

PostPosted: Fri Aug 31, 2012 3:15 pm
by enrico-sorichetti
NO
this is ( in case You forgot ) about file comparison
that one is about improving performance for a large sort

Re: File Comparison using ICETOOL

PostPosted: Fri Aug 31, 2012 3:26 pm
by thermalchu
Ok :oops:

Re: File Comparison using ICETOOL

PostPosted: Fri Aug 31, 2012 3:37 pm
by thermalchu
Since all IDs in both files are unique and same, I'm trying to do one-to-one matching. And will run compare twice.
Before I was able to compare first 3000 bytes of 7000 bytes by using this:

//DFSPARM DD *
OPTION DYNALLOC=(SYSDA,70),AVGRLEN=7000
/*
//TOOLIN DD *
SELECT FROM(SORTIN) TO(OUTPUT) ON(1,3000,CH) NODUPS
/*


Now I thought I will compare for first 3500 bytes like this:
//DFSPARM DD *
OPTION DYNALLOC=(SYSDA,200)
/*
//TOOLIN DD *
SELECT FROM(SORTIN) TO(OUTPUT) ON(1,3500,CH) NODUPS
/*

Eventhough allocating 200 SYSDA's it shows:
ICE046A 0 SORT CAPACITY EXCEEDED