Interested to Buy Any Domain ? << Click Here >> for more details...
I have two input files
i/p1
name id-key flag date
i/p 2
name id-key date
if id-key matches in the both the files then it should
write the output file from i/p1 with flag 'Y'. It should be
done thru JCL sort card ,Please provide the info on this.
---Note : output file should have all records from i/p1
with proper Flag.
- 2 Answers
- 5805 Views
- I also Faced
- E-Mail Answers
Answer Posted / vivek chandrasekaran
Give the two input files to be compared as
//SORTIN DD DSN=INPUT1,DISP=SHR
// DD DSN=INPUT2,DISP=SHR
//SORTOUT DD DSN=OUTPUT,DISP=...
//SORTXSUM DD DSN=MATCH,DISP=(NEW,CATLG,DELETE),..
//SYSIN DD *
SORT FIELDS=(11,5,CH,A),EQUALS
SUM FIELDS=NONE,XSUM
Considering name length 10 and key length 5 starting from
11 pos. XSUM will capture the duplicates. EQUALS will keep
the first duplicate record. To put 'Y' flag use OUTREC
FIELDS=(1:1,15,16:C'Y',17:17,8) considering date length 8
starting from 17 pos.
SUM FIELDS=NONE
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what EXEC statement is and what is the syntax of EXEC statement used in JCL?
What is timing concept in mainframe?
How to submit jcl through a cobol program?
Can an individual step be restricted from using all the jobs allowed cpu time?
Explain the function of the dd dcb keyword?
How to pass the parameter in parm using linkage section ? (syntax)?
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?
What is 'mounting' of volumes ? Is there anything that a programmer can do in it ? How to find currently mounted volume ?
How can the submitting users racf authority be overridden in a job stream?
Which statement is used to identify the private libraries in job?
What is catelog procedure and how many catelog procedure to use in one job?
Explain the purpose of dd * statement in jcl?
in a jcl, a large volume dataset is loaded to a table using bmcload in step1 and an image copy of the loaded table is taken using bmccopy in step2. Step2 abends because the image copy dataset cannot hold the volume of the table. How can this be rectified?
what is DSN parameter and DISP parameter is used for?
I want to join to input files and write the matching fields on to an output file but i dont want the output file a sorted one
