Thanks very much for the solution.
One more thing i want to know, if the no. of records changes so no. of DEPT-ID will change(suppose the input file is more than 1000 records with 10 types of DEP-ID), will the SORT will take care in this situation?
What i want to say is we won't get the input records same in all days, we will get different in each days.
In today we may get 10 records with 3 types of DEP-IDs,
In tomorrow we may get 90 records with 5 types of DEP-IDs,
In one day we may get 1000 records with 9 types of DEP-IDs
In one day we may get 5000 records with 18 types of DEP-IDs
Input Records may vary, so the DEP-IDs will change accordingly.
So the current SORT will handle this? will it work until end of record in the input file?
Thanks in advance.
In order to use JOINKEYS, you need z/OS DFSORT V1R5 PTF UK51706 (Nov, 2009), which you don't have. Ask your System Programmer to install it.
But note that z/OS DFSORT V1R5 and the z/OS release you are using are both out of service. You should move to z/OS 1.10, 1.11 or 1.12 with the corresponding level of DFSORT. So ask your System Programmer when you will be moving to a supported release.