Maching file with ICETOOL



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

Re: Maching file with ICETOOL

Postby pulcinella » Tue Apr 27, 2010 9:17 pm

Excuse skolusu, forget my last comment.

I finally need the records with 'A', 'B' and 'M' because after I have to update information at database. But, i don't understand why I have been cases where I obtain two record (one with a 'B' and the other with an 'M') diferent with the same key and the last 4 position different. When the key is the same and the last 4 position are diferent only must be write one only record with a 'M'.

Input file (after day)

xxxx027444740052
xxxx027444870443
xxxx027444900116
xxxx027445130443
xxxx027445260003
xxxx027445550091
xxxx027445710148
xxxx027446100443
xxxx027446230026
xxxx027446490054
xxxx027446520154
xxxx027447750443
xxxx027448270154
xxxx027448690037
xxxx027448720443
xxxx027448980037
xxxx027449080443

input file (before day)

xxxx027444160020
xxxx027444740052
xxxx027444870443
xxxx027444900116
xxxx027445130443
xxxx027445260003
xxxx027445550091
xxxx027445710148
xxxx027446100443
xxxx027446230026
xxxx027446490054
xxxx027446520052
xxxx027447750443
xxxx027448270154
xxxx027448690037
xxxx027448720443
xxxx027448980037

output
......
xxxx027446520052B
xxxx027446520154M
......

Do you know why happen? I need know it because If I do delete of record at database and after I want update database with the next record, I have a problem because the record not exist.

Thank you very much and excuse for my last comment
pulcinella
 
Posts: 114
Joined: Mon Dec 10, 2007 10:18 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Re: Maching file with ICETOOL

 

Re: Maching file with ICETOOL

Postby skolusu » Tue Apr 27, 2010 9:52 pm

pulcinella,

I finally need the records with 'A', 'B' and 'M' because after I have to update information at database. But, i don't understand why I have been cases where I obtain two record (one with a 'B' and the other with an 'M') diferent with the same key and the last 4 position different. When the key is the same and the last 4 position are diferent only must be write one only record with a 'M'.


*sigh* If only you had copied my control cards as is that would NEVER happen. Pay attention to the control cards I posted especially the SECTIONS statement where I am picking only 1 key based on the key.

You always show input which NEVER ever matches the rules or the output. I have no idea as to why the 027444160020 is not included in output and why 027444740052 is included in output when it is exists both files with the same exact key and ID. 027449080443 is completely missing from output.

I can't keep working on "n" different scenarios with you unless you come up with correct requirement. This will be my last post on this topic because I simply give up. Sorry

Just for your info this is what I get with your latest input

XXXX027444160020B
XXXX027446520154M
XXXX027449080443A
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times

Re: Maching file with ICETOOL

Postby pulcinella » Wed Apr 28, 2010 8:32 pm

Skolosu,

I can understand you're tired but, I've re-run and I get the same result. I keep coming in sometimes two records. I have reviewed your example but I have not found error. I'm sure I copied the same. Can be the size of files?
Anyway, do not worry. Will review where the error Thanks for your time and sorry for the inconvenience
pulcinella
 
Posts: 114
Joined: Mon Dec 10, 2007 10:18 pm
Has thanked: 0 time
Been thanked: 0 time

Previous

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post