To match and remove duplicate records from two files.

Ask/Clarify the questions on EASYTRIEVE

Moderators: DikDude, Moderator Group

Post Reply
abhishek_forum
Member
Posts: 1
Joined: Fri Feb 06, 2009 1:23 pm

To match and remove duplicate records from two files.

Post by abhishek_forum » Fri Feb 06, 2009 1:40 pm

Hello all,

I joined this forum recently.

I had one requirement.

I need to match two files and based on them I had write exception report

1. If the every record in fileA is not present in fileb,
2. if fileb contain any extra records,
3. if fileb contain duplicate records.

For first 2 req. I know I can use "IF MATCH FILEA FILEB"
But how to include 3rd condition with first two.

Please help me.

Regards,
Abhishek.

Purusothaman
Member
Posts: 4
Joined: Tue Nov 18, 2008 11:10 am
Location: Chennai, India
Contact:

Duplicates

Post by Purusothaman » Fri Mar 27, 2009 5:10 pm

You can use

IF MATCHED
IF DUPLICATE fileb
.....
END-IF
END-IF

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others