Need to search in 3 files and write output - Syncsort v1.2.3

ramsri · Active User Joined: 18 Oct 2008 Posts: 380 Location: India

Hi,

We are using SYNCSORT FOR Z/OS 1.2.3.1R. My requirement is as explained at the bottom after these files.

Input File-1:

Arun Raj · Posted: Wed Mar 25, 2009 9:22 am

Arun Raj · Posted: Wed Mar 25, 2009 9:29 am

Ramsri,

If you have only a few values to be checked as shown above, I think it would be much easier to go for a cobol solution.

ramsri · Active User Joined: 18 Oct 2008 Posts: 380 Location: India

Arun, sorry.......it is 8th column only. They are not few values they are going to be 99 unique values we get. Is it possible to achieve using Syncsort?

Thanks.

Arun Raj · Posted: Wed Mar 25, 2009 12:07 pm

Still I believe this is a good candidate to do some coding.

ramsri · Active User Joined: 18 Oct 2008 Posts: 380 Location: India

Arun, would you please post some pseudo code kind of thing so that I can try to come up with some COBOL for the same...........

I thought SORT is the best and fast to achieve it

Thanks.

Arun Raj · Posted: Wed Mar 25, 2009 3:57 pm

Ramsri,

From whatever I understood so far,

1.Load all the key values into a ws-array along with an additional field to indicate which file it belongs to.
2.Read the input file.
3.For each key from the input, do a search in the ws-array.
4.If found, Populate the output record arrays based on the indicator.
5.Write the output record for each output file only if the respective output array has at least only entry.

Let me know if I missed something.

ramsri · Active User Joined: 18 Oct 2008 Posts: 380 Location: India

Arun, is it possible to do a file to file comparision if I have to do look-up in only one file. I am going to combine all the three files into one file because they come from three different tables and unique values are assured.

Please suggest.

Arun Raj · Posted: Wed Mar 25, 2009 11:41 pm

dick scherrer · Posted: Wed Mar 25, 2009 11:48 pm

Hello,

Suggest you have spent much more time trying to not write the code than it would have taken to have simply written the code. . .

Keep in mind that if you write proper code, it can be easily maintained and enhanced while some "tricky" non-code solution may not work when the requirement changes. . .

Terry Heinze · Posted: Thu Mar 26, 2009 1:50 am

You left out at least one "rule". Can input file-2, input file-3, and input file-4 share any values? If so, are records written to ALL of the matching output files or only some of them or only the 1st found? You've been given good pseudo code already. I'd also opt for a COBOL solution.

ramsri · Active User Joined: 18 Oct 2008 Posts: 380 Location: India

Yes. Finally, I got it worked with COBOL solution only. Thanks.

Arun Raj · Posted: Thu Mar 26, 2009 10:01 am

Good to hear it's working.