IBM Mainframe Forum

Hi Everyone,

My requirement goes this way , Where i will be joining two files and will be sending the data which is matched into one file and other that doesn't match into an another file.I would like to issue a return code of RC4 if the unmatch file contains any data.

Below mentioned were the files:-

File1:-


File2:-


Match file:-


UnMatch file:-


Here i will be joining the two files based on fields present in column1 (TEST) as a key and will be writing the contents that match in both the files into a Match file , and others that doesn't match will be writing the details present in file1 into an UnMatch file , where i would like to issue an RC4 if the UnMatch file contains any data.

Can some one provide me the sort card in achieving the above.

Thanks in advance!!!

OK, check your documentation for NULLOUT, you can search here, there are some examples of its use.

I think the simplest way to use it will be in a second step, which just copies (one record is enough) the file. You'd have to reverse your condition code checking so that non-zero is OK, zero is not.

It might be more flexible to use an IDCAMS step, as you can set the MAXCC - if LASTCC = 0, set MAXCC to 4, for instance.

Hello,

Why are TEST4 and TEST5 in neither output file?

Hi Bill,

Thanks a lot. Will follow your inputs and shall let you know the outcome.

Hi Dick,

I was trying to move the unmatched contents present in file1 hence its present in the output file2.

Hello,

So, unmatched file2 records are to be completely ignored - right?

Yes dick it should be ignored!!!