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
- 4787 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 |
how to run batch program without jcl?
which parameter is use to declare the name of dataset in dd statement?
how to override PROC? please give answer in details. Please mention how to write it in JCL. Thanks in advance.
describe the exec statement,its meaning ,syntax and keywords?
if we are specifing joblib as well as steplib in job then at the time of execution how the process will complete
Where & How Do You Code Identifier In Jcl?
what are the technical terms for // /* in jcl
Hi, can we call catalog( say myproc } proc n times in jcl if so how please explain Thanks in advance
What is 'mounting' of volumes ? Is there anything that a programmer can do in it ? How to find currently mounted volume ?
i have a jcl containing header body and trailer .in header i have viswa body 2 6 1 9 7 trailer reddy .now i need to sort only body in either asecending or descending order how can i do it
If a field is declared as a comp-3 field and if we want to sort a dataset based on this field, then how will the sort card be??? e.g- if we want to sort by a field which is defined as a PIC X(5) then we will mention - sort fields=(1,5,ch,a). Likewise if a field is defined as PIC S9(10)COMP-3 then in this case how will the sort field be defined (because in this case a sign is also involved)???
define cond parameter in jcl?
COBOL 
