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?
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 |
i) Difference between ps, esds, ii) Difference between lrecl, blksize among PS, PDS issues? i.e in jcl at dcb
What u mean by include statement in JCL ?
How are datasets concatenated?
when we use sysprint and sysout statements
how to purge 50 initiators continuously?? console commands??
What type of versions we r using in mainframe (jcl, cobol, db2, vsam, cics)?
How to search strings in multiple dataset with conditions 'string1 & string2'?
how to resolve soc-7 ? please tell me
Explain about Specifying compiler options in the PROCESS (CBL) statement
What is one line to pass PARM from JCL to COBOL?
What are the difference between jcl and jes?
In DCB, what is LRECL,BLKSIZE,DSORG