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
- 121879 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
in a jcl, a large volume dataset is loaded to a table using bmcload in step1 and an image copy of the loaded table is taken using bmccopy in step2. Step2 abends because the image copy dataset cannot hold the volume of the table. How can this be rectified?
Explain the function of job statement in jcl?
what is “Cond= even” and “Cond=only”?
what is the purpose of coding class parameter in job statement?
How gdg are concatenated?
what EXEC statement is and what is the syntax of EXEC statement used in JCL?
How does jcl act on code(if you take a cobol program)?
Explain how can values be passed from the job stream to an executable program?
Are there any set of rules for the names of the steps used in a job? What are they?
Explain how can a stopped job be started again?
I want my job (careerride) to be executed in 1 minute and 2 seconds. How do I do that?
How do you run a COBOL batch program from a JCL? How do you run a COBOL/DB2 program?
what happens in conversion stage in job processing?
How can values be passed from the job stream to an executable program?
What is the maximum length of a single line of jcl?
