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
- 4714 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
Name what parameter directs the output of the job log dataset?
What is the syntax of JCL statement?
how can you check if a file is empty using jcl?
Explain the job statement in jcl?
What is NOTCAT ?
What is multithreading in jcl?
In sms datasets, what is the function of the dd mgmtclas keyword?
Which dd parameters are required?
what is the JCL statement consists of?
I have a COBOL program that ACCEPTs some input data. How do you code the JCL statement for this?
Explain the function of the dd dcb keyword?
How jcl work to handle various input output file operations?
how can the same proc be re-used and called by many jobs?
how you can direct the data to spool using SYSOUT option?
Hello Guys, I have 1+ Year Experience in MAINFRAME TESTING. After 1 Week I have an Interview With a Company on Mainframe Testing. Please Could You Guys Please Suggest me What Sections Should I prepare ?? ___Tell Me the Topic Or Appropriate Site & Links. ?? ---------------Thank You
