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 are some jcl statements that are not allowed in procedures?

728


can any one plzzzzzz tell the jcl code for creating ps using idcams

10517


When you specify multiple datasets in a JOBLIB or STEPLIB, what factor determines the order?

938


State the uses of syspring, sysin, sort fields, sum fields and dummy.

654


I HAVE A VB BLOCK WHICH IS USED AS INPUT IN COBOL CONATINING SOME RECORDS CAN I CHANGE THE FILE FROM VB TO FB?

2107






What is the maximum length of a single line of jcl?

829


What is jcl in mainframe?

690


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

652


What is the function of //cntl statement?

830


what is use of space parameter in dd statement?

758


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

700


i want to store 20 digits . how will u do it in cobol ?

860


when does a dataset go uncataloged?

835


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

636


How can a stopped job be started again?

711