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 / vinodh
IN SORT, YOU CAN USE JOINKEYS AND CAN TAKE 50 COMMON
RECORDS IN B/W 2 I/P FILES AND WRITE TO O/P FILE.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the motivation behind coding class parameter in job statement?
Suppose there are 2 Input files Infile-1 and Infile-2. Both the Files contain Employee Records. You need to compare both the files and Write the Common Records in third file named Outfile. How can we do this using File-Aid?
Differentiate between the joblib and the steplib statements?
Explain the function of the steplib dd statement?
How to code these statements in JCL: CLEANUP INITIAL(NO) RESTART(NO) DYNALLOC(NO) job definition..?
What is the purpose of dd?
How can a fb file convert to vb file using sort program?
In job processing, what happens in execution stage?
Explain the function of //jcllib statement?
how can a gdg base be created in a jcl. What is the difference between empty and scratch parameter while defining/altering gdg base?
What is the function of the steplib dd statement?
What is the function of the dd mgmtclas keyword in sms datasets?
Explain how can values be passed from the job stream to an executable program?
Can an individual step be restricted from using all the jobs allowed cpu time?
The disp in the JCL is MOD and the program opens the file in OUTPUT mode. What happens ? The disp in the JCL is SHR and the pgm opens the file in EXTEND mode. What happens ?