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 have a job (4 steps) with time parameter coded in job & exec, say time=10 in job & time =3,2,2,4 in each steps. Will the job executes successfully?
how to run batch program without jcl?
There are a set of 10 files and a customer will be selecting random no of files(i.e they may be more than 2, may not be in the order).Sometimes he might just select one file or sometimes no files at all.How do you code a JCL for this? Is it possible to code just JCL alone for this problem?
what is the function of spool command?
how to resolve sb37,sd37 se37 abends
I have mainpgm(abc) this is the only cobol pgm(non-db2).And this pgm calling subpgm name "acd" this also only cobol(non- Db)and this pgm calling some other subpgm this pgm has cobol-db2 pgm. 1) IF you calling static mode how to run and how to compile? 2) IF you calling dynamic mode how to run and how to compile? plz suggestion me.
what are the various stages of job processing?
wht r different types of sorts ?
What do you understand by the term notcat 2 – gs?
Write a JCL by using the below requirement: File1 =1, File2 =11 and output needs to come as File3 =111?
what is d/f b/w sysout & sysprint
what is the compile process of cobol program expalin with code