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...

Write a JCL by using the below requirement:
File1 =1, File2 =11 and output needs to come as File3 =111?

Answer Posted / mdv

Step 1.

Add SEQNUM for both the files @ positions 3 to 8 and 2 to 7
respectively.

Step 2.

Join based on key and reformat as needed.

// SYSIN DD *

JOINKEYS FILE=F1,FIELDS=(3,6,A)

JOINKEYS FILE=F2,FIELDS=(2,6,A)

REFORMAT FIELDS=(F1:1,2,F2:1,1)

SORT FIELDS=COPY

/*



Note: Not tested.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which dd parameters are required?

1114


What is job control language?

1034


how you will the direct the data to spool using sysout option?

2357


why should SYSIN DD * statement should not be included inside a PROCedure snippet??? please answer this.. i need to know.

2401


Differentiate between the joblib and the steplib statements?

1338


What does a disposition of (new,catlg,keep) for a dsn mean?

1071


Mainframes gets a text file that contains the name of the file. Now using JCL i want to locate that file name in the mainframe system and perform further processing. Please tell how to proceed

2507


Many jcl statements contain specific values designed to direct and control the execution of the statement. What are these fields called?

1169


How to do automated restart when a job abend?

1289


what JCL Procedures?

1195


How does the jcl specify the job to os?

1098


by using cond parameter maximum 8 cond can be coded in single cond means ?explain

1399


How can the disposition of sysout datasets be set for an entire jobstream?

1279


What are the rules employed while naming the steps in a job?

1092


In sms datasets, what is the function of the dd mgmtclas keyword?

1341