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
- 6022 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / muttaiah
Please give us a sample of both the I/P files and the data
you expect in O/P files so that it will be useful for us to
answer
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
What is the meaning of data definition name (ddname) and dataset name (dsname) in the DD statement?
Explain the function of the dd dcb keyword?
In a single step if input file is present then only need to copy into output file or else need to through a RC is it possible. Note : i want it in a single step
Differentiate between the joblib and the steplib statements?
What is the error in the following JCL statements : I) //step#three exec pgm=hkbc762 ii) //step#3 exec pgm = hkbc762 iii) //step#3 exec pgr = hkbc672
Can you delete the GDG base without deleting GDG generations ?
How we can code in a jcl to execute a job in a particular time and date without using any job shudular?. (Eg) i want to execute a particular job at 8 am on 01/01/2010.
Explain about LMMLIST�list a library's members
what is A-MODE and R-MODE?
What is the purpose of include statement in a JCL?
How to execute step2,step5,step7 of a proc of 10 steps? You are not allowed to change in JCL.
i have a jcl in which 4 & 5 step creates a new generation. 4th step output is as input for the 6th step & 5th step output is used as input in the 7th step. How they are refered as in the 6th & 7th steps? If the job abends in 6th step then how the 5th step output is refered in 7th step?
COBOL 
