Interested to Buy Any Domain ? << Click Here >> for more details...
File1 has 100 records and file2 has 200 records i want to
copy 50 records which r in both file into file3
- 7 Answers
- 11776 Views
- I also Faced
- E-Mail Answers
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
what happens when COND is coded in JOB statement and when COND is coded inside EXEC statement?
I have 60 steps in the JCL and want to Execute Only First from PROC by overriding in JCL ?
How does the jcl specify the job to os?
I have a COBOL program that ACCEPTs some input data. How do you code the JCL statement for this?
Explain the purpose of dd dummy statement?
Explain the function of the dd dcb keyword?
What is the significance of addrspc parameter in exec statement?
When space is allocated for an output dataset, what units can be used?
how do you access an uncataloged dataset in a jcl?
Explain the jcl exec statement?
Is automatic restart possible in jcl?
Is it possible to left uncode disp? If yes, how?
What is the function of the dd mgmtclas keyword in sms datasets?
What methodology can be adapted to transfer data to a program that is coded using the exec statement?
What are the 4 fields in dd statement?
