File1 has 100 records and file2 has 200 records i want to
copy 50 records which r in both file into file3
Answer Posted / madhavi chava
This can be coded as given below
//SORT1 EXEC PGM=SORT
//SORTJNF1 DD *
00000111111 000001234567 LOCAL =====
00000333333 000003456789 LOCAL =====
00000555555 000005678901 EXTRN =====
00000666666 000006789012 EXTRN =====
00000777777 000007890123 LOCAL =====
//SORTJNF2 DD *
00000222222 000002345678 ===== BCDEF
00000444444 000004567890 =====
DEFGH
00000666666 000006789012 ===== FGHIJ
00000888888 000008901234 ===== HIJKL
00000999999 000009012345 ===== JKLMN
//SORTOUT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD *
JOINKEYS FILES=F1,FIELDS=(1,11,A,13,12,A)
JOINKEYS FILES=F2,FIELDS=(1,11,A,13,12,A)
REFORMAT FIELDS=(F1:1,31,F2:32,5)
SORT FIELDS=COPY
output of the file3
00000666666 000006789012 EXTRN FGHIJ
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Differentiate between the joblib and the steplib statements?
What is job control language?
List in order the hierarchical levels of jcl?
Explain about ISPF/TSO Commands
What parameters can be used to limit the number of records written to a sysout dataset?
I need exexution process for JCL programs
What is jcl in mainframe, and how many types of jcl statements are there for a job?
Explain how can a stopped job be started again?
Explain the function of a dd statement?
define cond parameter in jcl?
which utility is used a dummy utility?
what is DD statement is used in JCL?
How to find the UNIT and VOLUME of a (a) KEPT (b) UNCATALOGED and (c) CATALOGED dataset - using (i) JCL and using (ii) ISPF ?
Explain about LMFREE�free data set from its association with data ID
In sms datasets, what is the function of the dd mgmtclas keyword?