Interested to Buy Any Domain ? << Click Here >> for more details...
I have 15 flat files. each record in the files have the
monthly salary for 12 months with the employee number. Now
I want to concatenate the 15 files such that for the
employee numbers that are common the o/p file should have
only one record and the salaries should be concatenated to
that record. How can we do it with JCL?
- 1 Answers
- 4808 Views
- I also Faced
- E-Mail Answers
Answer Posted / sk
For understandability just concatenate all the 15 flat file
use of simple concatenation.(It's like use first file name
with DD name and all the other 14 files without DD name and
write in adjucent). so you got the 15 files data in one
file, Next step is , sort the file using key as employee
number and use SUM FIELDS for concatenating the salaries,
so it will remove the duplicateas well as it will get the
concatenated result of the salary.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is their any set of rules for dd? Explain.
We can use PASS with permanent datasets also. THEN Which is the condition in which we may use PASS (instead of KEEP) with permanent data sets, while there is no need to specify UNIT and VOL for them like temporary data sets (in cas we use KEEP for permanent data sets) ?
What is jcl in mainframe, and how many types of jcl statements are there for a job?
i want to store 20 digits . how will u do it in cobol ?
Explain dd statement in jcl?
What is the purpose of dd dummy statement?
what is use of space parameter in dd statement?
What is timing concept in mainframe?
Is acct parameter mandatory?
a dd statement has 2 types of parameters. Name them?
which parameter is used to check the syntax of a jcl without executing it?
What is notcat 2 - gs?
Give the syntax of job specifying jcl statement.
What is the function of the dd mgmtclas keyword in sms datasets?
Matching Logic in Jcl not in cobol.Could any one please answer this question
