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
- 4926 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
I want my job (careerride) to be executed in 1 minute and 2 seconds. How do I do that?
What is catelog procedure and how many catelog procedure to use in one job?
in a jcl, a large volume dataset is loaded to a table using bmcload in step1 and an image copy of the loaded table is taken using bmccopy in step2. Step2 abends because the image copy dataset cannot hold the volume of the table. How can this be rectified?
IIN APITUDE THEY GAVE ONLY 10 QUESTIONS.. THEY ARE SIMPLE ONE FROM NUMBER SERIES,BOATS,TIME & DISTANCE,PROFIT &LOSS,FIND OUT THE NUMBER ? 9 25 4 36 81 64 49 AND surveillance SPELLINGS E.T.C
Explain dd statement in jcl?
What dd statement is used to supply the name of a dataset?
Which dd parameters are required?
What are the rules employed while naming the steps in a job?
What do you know about jcl?
what happens when COND is coded in JOB statement and when COND is coded inside EXEC statement?
Can an individual step be restricted from using all the jobs allowed cpu time?
Does jcl support automatic restart?
Is it possible to left uncode disp?
Step 1 RC 4 Step 2 Step 3 I want to know the COND parameter which can be coded in step 2 or 3. Step 2 should be executed based on Step 1 RC and Step 3 should not be executed based on step 1's RC
what are JCLLIB and STEPLIB in JCL?
