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

oza017.myorg.emp has 100 records ,oza018.myorg.staff has
200 records but 50 are the common records in both files
copy all the common records into oza017.myorg.xyz dataset

Answer Posted / challa srinivas

//SORT1 EXEC PGM=SORT
//SORTJNF1 DD DSN = oza018.myorg.staff
DSN = oza017.myorg.emp
//SORTOUT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD DSN = oza017.myorg.xyz
JOINKEYS FILES=F1,
JOINKEYS FILES=F2,
REFORMAT FIELDS
SORT FIELDS=COPY

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between the positional and keyword parameters? Give examples.

1193


How to pass data to a program that is coded in an exec statement?

1271


what is DSN in JCL and what are the parameters to declare the DSN?

1149


How to submit jcl through a cobol program?

1101


Which dd parameters are required?

1119


Explain how can an in-stream dataset be terminated?

1252


What is the function of dd name parameter with a 2 part structure; audit.report?

1173


How gdg are concatenated?

1065


Explain how can the attributes of one sms dataset be copied to another dataset?

1161


In job processing, what happens in conversion stage?

1150


what disp parameter we mention for creation of temporary dataset so that we can use it in later steps?

1163


Explain the function of //jcllib statement?

1162


Describe the various parameters utilized in the creation of a gdg?

1104


What is condition checking in jcl? Is this possible?

1062


if we want to use a gdg which is already created by some job, then how to use the reference of the last generation in a jcl?

2223