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
- 3946 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
can u execute a proc from another proc?
What is the difference between joblib and jcllib statements
when GDG version number get changed ? bcz always Generations only increasing.
what is JCL?
How would you understand error(execution phase)?
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
How can the disposition of sysout datasets be set for an entire jobstream?
I have 10 steps, I want to run STEP1 TO STEP4 then I should not run STEP5 and STEP6. Aganin I want to execute from STEP7 to STEP10. ONLY using CONDITION CODES how can we execute this process? 1. Where we can set cond codes for STEP5 and STEP6? 2. How can we execute remaining steps from STEP7 to STEP10?
how many types of sorts are there in jcl?
can we give instream data in procedure
Is their any set of rules for dd? Explain.
I have 5 steps in my job. say s1, s2, s3, s4, s5 //s1 exec ............. //s2 exec ............ //s3 exec .......... //s4 exec ........ //s5 exec ............... my question is i want to exeute only s2 and s4 steps... please advice me how to do this:
COBOL 
