Interested to Buy Any Domain ? << Click Here >> for more details...
Wrete a JCL to compare two files and mached records move to
onc file & un mached rows wants to another file?
- 13 Answers
- 121739 Views
- CGI, DSRC, IBM, I also Faced
- E-Mail Answers
Answer Posted / rams
Every one answered well. I would like to emphasize on few
details.
SORTXSUM and ICETOOL are used to identify the duplicate
records Depending on what kind of SORT utitlity you are
using. SORTXSUM works in SYNCSORT. It does n't work in
DFSORT ( you can use ICETOOL in this case ).
If you use the above ICETOOL code for comparing 2 SORTIN
files, The results may not be accurate because the record
may be duplicated in the second file and does not exist in
the first one.
When you use SUM FIELDS=NONE, you need to specify a key
based on which the duplicated can be deleted, IF you use
SORT FIELDS=COPY it may not work ( or delete duplicates by
entire record...i am not sure though)
There is a small diff in the ICETOOL and SORTXSUM work. If
you have 1,2,3,4,4,4,5,5,6,7 in you i/p file.
The SORT ourfile will have 1,2,3,4,5,6,7 and SORTXSUM file
will have 4,4,5.
The ICETOOL ALLDUPS will have 4,4,4,5,5 and NODUPS file
will have 1,2,3,6,7.
| Is This Answer Correct ? | 20 Yes | 12 No |
Post New Answer View All Answers
which parameter is used to check the syntax of a jcl without executing it?
what is use of dcb parameter in dd statement?
how do you access an uncataloged dataset in a jcl?
For what purpose steplib and joblib are used ?
State the uses of syspring, sysin, sort fields, sum fields and dummy.
what is use of space parameter in dd statement?
what are the types of abends that occur on job failure? And explain the possible causes of these
What do you understand by the term job time – out and how can you overcome that?
Explain how can the submitting users racf authority be overridden in a job stream?
Explain the jcl exec statement?
Explain the function of //cntl statement?
How can return codes be tested before execution of a job step?
What is the function of dd disp parameter?
I have a COBOL program that ACCEPTs some input data. How do you code the JCL statement for this?
How can values be passed from the job stream to an executable program?
