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 motivation behind coding class parameter in job statement?

680


How to pass the parameter in parm using linkage section ? (syntax)?

645


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

1757


For what purpose steplib and joblib are used ?

682


How does jcl specify the job to the operating system?

745






Is their any limit for data sets?

699


We can use PASS with permanent datasets also. THEN Which is the condition in which we may use PASS (instead of KEEP) with permanent data sets, while there is no need to specify UNIT and VOL for them like temporary data sets (in cas we use KEEP for permanent data sets) ?

1762


Is it possible to left uncode disp? If yes, how?

704


What is condition checking in jcl? Is this possible?

619


when does a dataset go uncataloged?

826


Name a few IBM utility programs, and explain its function.

4429


I have a job called careerride and some steps in it as step1,step2. But I want to execute step2 before step1 ? How do I do that?

823


How can a stopped job be started again?

707


What is the function of //jcllib statement?

798


When The Define Jcl Is Not Available, How Can You Get Information About A Vsam File's Organisation ?

741