Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?



I have 15 flat files. each record in the files have the monthly salary for 12 months with the empl..

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

Post New Answer

More JCL Interview Questions

In JCL I have 5 steps,I need to execute 1st,2nd and 5th steps only,can any one answer me please?

2 Answers   TCS,


how to create a member or sequential dataset through tso command??

4 Answers  


why do we use file-aid wht r the adv of using file-aid thn in ispf

7 Answers   HCL, Tech Mahindra,


Suppose there r total 10 steps. Out of which i want to execute only the 7th step. How can i do that....????

3 Answers  


Suppose there are 10 steps in a PROC, I want to execute only step5. How do you give the condition in the JCL that calls this PROC?

3 Answers   IBM,


What is the difference between specifying DISP=OLD and DISP=SHR for a dataset?

2 Answers  


I have 5 steps in my job. say s1, s2, s3, s4, s5 //s1 exec ............. //s2 exec ............ //s3 exec .......... //s4 exec ........ //s5 exec ............... my question is i want to exeute only s2 and s4 steps... please advice me how to do this:

4 Answers   ITC Infotech, TCS,


What is GDG and what is the maximum limit of versions that can be created?

9 Answers   Convergys,


i have records from 1 t0 100 . i need to open records from 10 to 18 and change the values in tht ? how can i do tht ?

2 Answers   Syntel,


Explain about File Tailoring

1 Answers  


JCL Example: // //RUNJCL JOB CLASS=5,MSGCLASS=6,NOTIFY=&SYSUID //STEP01 EXEC PGM=IEFBR14 // .. .. If this JCL will run or it'll throw the ERROR?

4 Answers   HCL,


SORT card to eliminate duplicity.

1 Answers   Syntel,


Categories