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
- 4922 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 |
The maximum number of in-stream procedure you can code in any JCL is ?
What are hierarchy levels in jcl?
In SPACE,what is directory,RLSE
What do you do if you do not want to keep all the space allocated to a dataset?
how to resolve soc-7 ? please tell me
If i am going to change some variable in a copybook( size or variable type) ,what are the changes that need to be done in the corresponding JCL.
what are the symbolic parameters? why do we use symbolic parameters ?
2 Answers IBM, TCS, UST, Xansa,
why jobstep can't be more than 255 and for GDG has max limit 255 . Is there any relation between the two
Can we use COND=EVEN on a job card, when jobs are scheduled through scheduler?
How to concatenate different LRECL of files?
Definition of COND parameter in JCL
Are there any set of rules for the names of the steps used in a job? What are they?
COBOL 
