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
- 5917 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
When you specify multiple datasets in a JOBLIB or STEPLIB, what factor determines the order?
Many jcl statements contain specific values designed to direct and control the execution of the statement. What are these fields called?
hello friends ,i have exam in Hsbc,pls any on send me placement papers and technical questions on mainframes,thank u
A chkpt is the parameter coded for multi-volume qsam datasets in a dd statement. When a chkpt is coded as chkpt=eov, a checkpoint is written to the dataset specified in the sysckeov statement at the end of each volume of the input/output multi-volume dataset. State whether true or false?
How to do automated restart when a job abend?
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
Is automatic restart possible in jcl? If yes, how?
How does jcl act on code(if you take a cobol program)?
what is DD statement is used in JCL?
Does jcl support automatic restart?
Define concatenating?
Is condition checking possible in jcl? If yes, how?
How can the disposition of sysout datasets be set for an entire jobstream?
Is their any limit for data sets?
How can the attributes of one sms dataset be copied to another dataset?
