File Comparison using ICETOOL



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Re: File Comparison using ICETOOL

Postby NicC » Fri Aug 31, 2012 1:06 pm

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.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: Re: File Comparison using ICETOOL

 

Re: File Comparison using ICETOOL

Postby thermalchu » Fri Aug 31, 2012 1:32 pm

k :)
I'll try..
thermalchu
 
Posts: 38
Joined: Thu Aug 30, 2012 3:47 pm
Has thanked: 0 time
Been thanked: 0 time

Re: File Comparison using ICETOOL

Postby BillyBoyo » Fri Aug 31, 2012 1:32 pm

Do you have duplicates on the keys, I asked. Either file.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: File Comparison using ICETOOL

Postby thermalchu » Fri Aug 31, 2012 1:36 pm

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..
thermalchu
 
Posts: 38
Joined: Thu Aug 30, 2012 3:47 pm
Has thanked: 0 time
Been thanked: 0 time

Re: File Comparison using ICETOOL

Postby BillyBoyo » Fri Aug 31, 2012 1:46 pm

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,?)
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: File Comparison using ICETOOL

Postby thermalchu » Fri Aug 31, 2012 3:09 pm

I'm trying, Taking time because of x-wait...
thermalchu
 
Posts: 38
Joined: Thu Aug 30, 2012 3:47 pm
Has thanked: 0 time
Been thanked: 0 time

Re: File Comparison using ICETOOL

Postby thermalchu » Fri Aug 31, 2012 3:10 pm

dfsort-icetool-icegener/topic6864.html

Isn't this post similar to ours?
thermalchu
 
Posts: 38
Joined: Thu Aug 30, 2012 3:47 pm
Has thanked: 0 time
Been thanked: 0 time

Re: File Comparison using ICETOOL

Postby enrico-sorichetti » Fri Aug 31, 2012 3:15 pm

NO
this is ( in case You forgot ) about file comparison
that one is about improving performance for a large sort
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2643
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 130 times

Re: File Comparison using ICETOOL

Postby thermalchu » Fri Aug 31, 2012 3:26 pm

Ok :oops:
thermalchu
 
Posts: 38
Joined: Thu Aug 30, 2012 3:47 pm
Has thanked: 0 time
Been thanked: 0 time

Re: File Comparison using ICETOOL

Postby thermalchu » Fri Aug 31, 2012 3:37 pm

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
thermalchu
 
Posts: 38
Joined: Thu Aug 30, 2012 3:47 pm
Has thanked: 0 time
Been thanked: 0 time

PreviousNext

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post