Page 2 of 2

Re: Using DFSORT to match and process two input files

PostPosted: Sat Jul 10, 2010 12:51 am
by Frank Yaeger
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.

Re: Using DFSORT to match and process two input files

PostPosted: Sat Jul 10, 2010 1:02 am
by webber
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.

Re: Using DFSORT to match and process two input files

PostPosted: Sat Jul 10, 2010 1:03 am
by webber
I'm sorry, i didn't mention it after all, but i started using jcl and cobol only 3 days ago.

Re: Using DFSORT to match and process two input files

PostPosted: Sat Jul 10, 2010 1:22 am
by Frank Yaeger
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.