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
- 5908 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
How to execute 2nd and 4th steps among 5 steps in jcl proc?
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) ?
What is the function of dd disp parameter?
How can a stopped job be started again?
Does jcl support automatic restart?
Explain the function of the dd dcb keyword?
How do you overcome this limitation ?
What are steplib and joblib? What for they are used?
I HAVE A VB BLOCK WHICH IS USED AS INPUT IN COBOL CONATINING SOME RECORDS CAN I CHANGE THE FILE FROM VB TO FB?
Many jcl statements contain specific values designed to direct and control the execution of the statement. What are these fields called?
what are the types of abends that occur on job failure? And explain the possible causes of these
Explain dfsort utility?
Which statement is used to identify the private libraries in job?
If a (+1) generation dataset is created in the first step of a job, how can it be referenced in later steps of the same job for input?
What does a disposition of (new,catlg,keep) for a dsn mean?
