Using DFSORT to match and process two input files



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

Re: Using DFSORT to match and process two input files

Postby Frank Yaeger » Sat Jul 10, 2010 12:51 am

Thank you!

It doesn't seem to work very well but i will look into it further.


What a strange response. Why would you thank me twice for something you think doesn't work?

It works fine based on the description you gave me of what you wanted. I don't know what you mean by "it doesn't seem to work very well". In what way? Of course, I don't know what job you actually ran or what data you actually used. The job I showed gave the results you asked for with the data you showed - I always test the solutions I give out. If it didn't work very well, then I would guess you didn't describe what you wanted very well (GIGO).

Meanwhile i managed to achieve the desired output using splice and making a set of comparisons.


The job I showed does use SPLICE and does make a set of comparisons. I don't know what you did differently since you didn't bother to show your job.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Re: Using DFSORT to match and process two input files

Postby webber » Sat Jul 10, 2010 1:02 am

I thanked you for your effort of responding to my request and as i'm usually polite, it seemed apropriate to thank you for you trouble and kindness.

I tried to use the job you gave me but the output wasn't the expected as two files were empty and one included a mix of records that didn't even existed on the input.

As i said when i posted my problem, i started working with jcl and cobol three days ago, so i dont understand the language and half the code you wrote.
Most likely i screwed up copying the job and it shoudl work fine.

My solution lacks the simplicity of yours and most likely the efficiency.
It's a 3 step job in which on the first step i produce the first two output files with the records only present in input 1 and input 2, and a third file with the duplicates.
Then by comparing the file with the input again i start to reduce the universe of records until i produce an output with only the ones that have been modified.

I simply didn't show you my result because i can't copy the file in any matter out of the machine were i'm using it, and i didn't bother to copy the job by hand and after that in here.

As i said i will look further into it tomorrow but for now my solution solves my problem.

Thank you once again.
webber
 
Posts: 8
Joined: Thu Jul 08, 2010 2:29 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Using DFSORT to match and process two input files

Postby webber » Sat Jul 10, 2010 1:03 am

I'm sorry, i didn't mention it after all, but i started using jcl and cobol only 3 days ago.
webber
 
Posts: 8
Joined: Thu Jul 08, 2010 2:29 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Using DFSORT to match and process two input files

Postby Frank Yaeger » Sat Jul 10, 2010 1:22 am

Most likely i screwed up copying the job and it shoudl work fine.


Well, if you had said that in your previous post, I would not have had a problem with it. But you didn't, so I thought you were implying that I gave you a solution that didn't work, which annoyed me. Peace.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Previous

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post