Help on ICETOOL

main_prem · New User Joined: 16 Mar 2005 Posts: 8 Location: chennai

I have two input file A and B. I need the records from both the input files A and B. If A key matches with the B file key, I need to write to output file only from file A not from file B.

for eg:

A- file DATA
-------------

enrico-sorichetti · Posted: Tue Oct 12, 2010 8:30 pm

there is a language barrier here, or You made a mistake in pasting/describing the content of the files

since in the case posted the A and B file keys are the same all the output records should come file A

please post a more significant sample and use the code tags
and clarify better Your requirement

seems silly to put a requirement on the tool to be used for a task
would it make so much difference if instead of ICETOOL SORT were used ???

Frank Yaeger · Posted: Tue Oct 12, 2010 9:59 pm

main_prem,

11111111111111111

Where did this output record come from? It is not in either input file.

It's not clear from your explanation and example what it is you want to do.

What is the RECFM and LRECL of each input file?

Can input file1 have duplicates within it? Can input file2 have duplicates within it?

Please show a better example including duplicates within files if appropriate, and explain clearly the rules for getting from input to output.

Also, run this job and show the //SYSOUT messages you receive, so I can see what level you're at:

main_prem · New User Joined: 16 Mar 2005 Posts: 8 Location: chennai

Hi Frank,

Sorry, I think I did a mistake while copying the example.

Here is my requirement..

File A
------

main_prem · New User Joined: 16 Mar 2005 Posts: 8 Location: chennai

Frank,

I am at home now and I cant create the sysout now.

Thanks!

main_prem · New User Joined: 16 Mar 2005 Posts: 8 Location: chennai

To Add more:

Input file B is VSAM-KSDS and huge volume data it contains.

Frank Yaeger · Posted: Wed Oct 13, 2010 1:23 am

main_prem · New User Joined: 16 Mar 2005 Posts: 8 Location: chennai

Frank,

I did some analysis in my job and found Input File B will not have any duplicate and that is VSAM-KSDS file.

So now Its clear Input file A and B will not have duplicate INSIDE the file while it coming into ICETOOL operation.

When matching the key fields A and B files, there will be duplicates at that scenario we need to take the File A record and write into output file. we should not take the B file record.

Business behind is, daily Input A file will have come up with some updates that same record will be present in file B already, In that case we need to take the record from file A to output file. Needs to ignore the B file record.

I think, Now if you see my reply posted at "Tue Oct 12, 2010 11:17 pm" will be clear.

Thanks for your quick response!

Frank Yaeger · Posted: Wed Oct 13, 2010 10:34 pm

Here's a DFSORT job that will do what I think you asked for:

main_prem · New User Joined: 16 Mar 2005 Posts: 8 Location: chennai

Frank,

Thanks a lot!!!!!

You are really Great!!

Its working perfectly..

One question..Can I attain this through ICETOOL? SYSIN keywords are same?

Anyhow. just a question..I think i requirement is done.

Thanks Again!!!!!

Frank Yaeger · Posted: Thu Oct 14, 2010 10:59 pm

Here's a DFSORT/ICETOOL job to do the same thing: