File1 has 100 records and file2 has 200 records i want to
copy 50 records which r in both file into file3
Answer Posted / kamaldeep
We can't use SUM FIELDS=NONE,XSUM as mentioned by Harsha.
if we merge 2 files then it may be the case that input file already has duplicate records, so it will not give required output.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what disp parameter we mention for creation of temporary dataset so that we can use it in later steps?
What are the parameter we cannot use in procedure? How many instream we can write in single jcl?
What are hierarchy levels in jcl?
Explain the purpose of dd * statement in jcl?
Explain about LMQUERY�give a dialog information about a data set
What statement marks the beginning of an in-stream or cataloged procedure in jcl and assigns default values to parameters defined in the procedure?
Explain the function of a dd statement?
what is DD statement is used in JCL?
1) SORT FIELDS=(20,4,CH,D,10,3,CH,D) OUTREC FIELDS=(7:20,4,C' FUTURE ',20,2,10,3,1Z,1,9,13,7, 24,57,TRAN=LTOU,6X'FF') This example illustrates how a fixed-length input data set can be sorted and reformatted for output. The SORTIN LRECL is 80 bytes. The reformatted output records are fixed length with a record size of 103 bytes. SOLRF (the IBM-supplied default) is in effect, so unless the SORTOUT LRECL is specified or available, it will automatically be set to the reformatted record length of 103. in the above example i have some doubts that a) sort fields=(20,4,CH,D,10,3,CH,D) -what exactly it does and this fields related to output record fields or input record fields b)outrec used to refprmat the records after sorting that means could please reply me as soon as possible Thanks. Venkat
How dummy is used in jcl?
why should SYSIN DD * statement should not be included inside a PROCedure snippet??? please answer this.. i need to know.
What do you understand by the term job time – out and how can you overcome that?
What is the purpose of disp parameter?
What is the purpose of the dd keylen parameter?
What are the parameter we cannot use in procedure?