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
- 122188 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
whats the diff bw the evaluate also and and?
Explain the function of dd name parameter with a 2 part structure; audit.report?
how to run batch program without jcl?
List the different jcl statements that are not permitted in the procedures?
when can a job time-out occur? How to overcome that?
What is the difference between run mode and addressing mode?
Explain how can the disposition of sysout datasets be set for an entire jobstream?
I have many files which i am receiving from client everyday. I have one step for every file to check for empty or not. Here client gives 30 files i need to check for every file for empty or not and i need to perform 30 steps. Can I do it in single step. Dynamically i need to change the File name in my step.
What is one line to pass PARM from JCL to COBOL?
What is the job entry system used in your project? based on what criteria the sequence of jobs are picked if priority is not mentioned in the job card?
write a jcl to execute a job by 7:00 am on jan 20,1986?
How dummy is used in jcl?
Why block size is multiple of lrecl in jcl?
what JCL Procedures?
what EXEC statement is and what is the syntax of EXEC statement used in JCL?
