Interested to Buy Any Domain ? << Click Here >> for more details...
Hi,
I have a requirement
File A : I have 6 records out of which 4 are same.
File B: I have 8 records out of 6 records are same.
The 4 records in FILEA and 6 records in FILE B are same. If
we substract we will get two records, I need these two
records in output file
This is because to remove the duplicates from the database.
Through easytrieve we can compare but for that there should
not duplicates, but in my file I have duplicates.
Thanks in advance!!
- 2 Answers
- 10771 Views
- I also Faced
- E-Mail Answers
Answer Posted / vijay
It is simple, you no need to code ezt pgm for eliminating
the duplicate records. Try these 2 steps to eliminate the
duplicates.
Step-1: Use sort on file 1 and use sumfields=none on the
key field, then you can get only 2 records in the output
file.
Step-1: Follow the above procedure for the file 2.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Explain how can the attributes of one sms dataset be copied to another dataset?
what is the compile process of cobol program expalin with code
I want my job (careerride) to be executed in 1 minute and 2 seconds. How do I do that?
What are the parameters that are used in creating a gdg?
Explain how can values be passed from the job stream to an executable program?
Explain the function of //jcllib statement?
Name what parameter directs the output of the job log dataset?
Step 1 RC 4 Step 2 Step 3 I want to know the COND parameter which can be coded in step 2 or 3. Step 2 should be executed based on Step 1 RC and Step 3 should not be executed based on step 1's RC
what happens in execution stage in job processing?
a set statement is used to define commonly used symbolic across job steps or procedures. It initializes the previous values in the symbolic names. It has to be defined before the first use of the symbolic names in the jcl. State whether true or false?
Is automatic restart possible in jcl? If yes, how?
What is one line to pass PARM from JCL to COBOL?
Explain how can return codes be tested before execution of a job step?
Name a few IBM utility programs, and explain its function.
what is DSN in JCL and what are the parameters to declare the DSN?
