two reports to compare , both different format - URGENT

In this Mainframe Forum - You can post your queries on DFSORT, ICETOOL , SyncSort & JCL Utilities

Moderators: Frank Yaeger, Moderator Group

Post Reply
ar3
Member
Posts: 2
Joined: Mon Jul 13, 2009 6:25 pm
Location: chennai

two reports to compare , both different format - URGENT

Post by ar3 » Wed Jul 15, 2009 10:53 am

Hi All/Frank,

I have two reports which are of different format. each field's values are to be compared and match and mismatch records are to be pulled out of it.. im think of seperating all the account numbers by the first two numbers in a separate file and the sorting them into one file and then comparing them .. is it a good way.. or u have another idea.. if its ok can u give me some similiar code ...

thanks,
Arthi

User avatar
Frank Yaeger
Moderator
Posts: 812
Joined: Sat Feb 18, 2006 5:45 am
Location: San Jose, CA
Contact:

Post by Frank Yaeger » Wed Jul 15, 2009 7:57 pm

Since it's "URGENT", you should have given more details so somebody could help you. You haven't given enough information for me to guess what you're trying to do.

Perhaps the technique shown in the "Create files with matching and non-matching records" Smart DFSORT Trick will help. It's at:

http://www.ibm.com/support/docview.wss? ... g3T7000094

If you need more specific help, show an example of the records in each input file (relevant fields only) and what you expect for output. Explain the "rules" for getting from input to output. Give the starting position, length and format of each relevant field. Give the RECFM and LRECL of the input files. If file1 can have duplicates within it, show that in your example. If file2 can have duplicates within it, show that in your example.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort

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