I want to merge both these files into a third dataset and also it should be without any duplicates.So Please help me on this how to achieve this in a one step?
OK, you want to "merge" two different datasets with different numbers of records and drop the duplicates.
If you have "no key" it is either "impossible" or you use the whole record as a key.
Makes me wonder now what you mean by "merge".
You MERGE on files which are already in sequence on your key (even if it the whole record). As the first few bytes of your records were obviously not in sequence, I presumed (and certainly wasn't going to spend time checking) that you had some other key that was in sequence.
So, it really sounds like you want to SORT, on the entire record, with SUM FIELDS=NONE? Concatenate your input datasets on SORTIN. Give it a whirl.
Joined: 24 Jul 2011 Posts: 651 Location: Down on the pig farm
Posted: Fri Dec 07, 2012 2:21 am Post subject:
Whatever - why is this in the JCL forum? You cannot do this with JCL - except use the JCL to run a program (probably a sort program) to do what you want. If you think it can be done with JCL then look in the JCL manual. _________________ Regards
Oops output order is in Alphabetic way. Sorry! then I think it will be helpful if we can add a SEQNUM at the end of each record, remove duplicates and then sort it back using the SEQNUM. _________________ Thanks
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum