Hi,
I have a requirement to check dates in two files and abend if not equal.
I have done it in two steps , Can anyone help me to do this in one step.
As I have multiple files , so lesser the steps in the jcl would be good.
in order not to have people spend time on a competitor' s product
find out the <sort> product You are using ...
ICE messages IBM DFSORT
WER messages SYNCSORT
Run this job and show the //SYSOUT messages you receive, so we can see what sort product You are using and it' s level
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
You know that you will be sorting, by default, your two input files?
That's a lot of effort to just find two records to check.
Plus, I'm still saying it would be very easy to get a "false match" with your sort cards. OK, your data may preclude that, but you are doing multiple files. I don't like the thought of a bad solution replicating. It is bad, becuase when it works it works by accident rather than design, and when it doesn't it doesn't.
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
knickraj wrote:
Sabari,
yes no matching record other than first one.
thanks, i got the expected result with NULLOFL and NULLOUT.
knickraj,
You shouldn't be developing a solution that there are no matches except on the first record. As Bill mentioned, you are using joinkeys without limiting the number of records to match. Joinkeys runs 2 subtasks and assuming you have 1 million records in each file , you are wasting a lot of resources. Also there is a chance of "false match".
Use the following DFSORT JCL which will limit the number of records the subtasks read and match. You don't need another step to check for the return code and abend. You can do it all in a single step.
Skolusu,
Thanks for your suggestions,
As per the requirement I am only building input files, after some sorting ,so the data in the file would be correct and both files have only 1 record.