Are there duplicates in the files?
It would be great if you could show sample input and expected output..
Also seeing your older posts,
Some time you have asked DFSORT solutions and some times SYNCSORT so again you need to confirm sort product you are using.
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
This is a link to the DFSORT smart tricks documentation which has many examples of matching records.
Please click HERE to access it.
Because the solution for sort related questions may vary from product to product, please ensure that you state clearly which sort product you are using.
If you are not sure, then by running a simple sort step shown below, you will be able to find out for yourself.
If the messages start with ICE then your product is DFSORT. Please also post the output of the complete line which has a message code ICE201I, as this will enable our DFSORT experts to determine which release of DFSORT that you have installed. This may also affect the solution offered.
If the messages start with WER or SYT then the product is SYNCSORT and the topic will be moved into the JCL forum by one of the moderators. Please also post the information telling which version of SYNCSORT is installed, as this may also affect the solution offered.
Thank you for taking your time to ensure that the valuable time of others is not wasted by offering inappropriate solutions which are not relevant due to the sort product being used and/or the release that is installed in your site.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
vsrao_2k,
DFSORT supports JOINKEYS. If you don't have the Nov, 2009 PTF for JOINKEYS, ask your System Programmer to install it (it's free). For more information, see:
If you don't have that PTF and can't get your System Programmer to install it, run the following DFSORT job and post the //SYSOUT messages so I can see what level you're at:
Also, show an example of the records in each input file (relevant fields only) and what you expect for output. Explain the "rules" for getting from input to output. Give the starting position, length and format of each relevant field. Give the RECFM and LRECL of the input files. If file1 can have duplicates within it, show that in your example. If file2 can have duplicates within it, show that in your example.