Comparing large VB files with ICETOOL

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

Moderators: Frank Yaeger, Moderator Group

Post Reply
pwoubshet
Member
Posts: 1
Joined: Fri Feb 25, 2011 9:30 am

Comparing large VB files with ICETOOL

Post by pwoubshet » Fri Feb 25, 2011 10:12 am

Hi,

I have two VB files and want to identify records that exist on file 1 and do not exist on file 2. I want to output these records to a new file 3 with the same format.
This is a full record compare and the approximate record count of each file is 2 million.

File 1
LRECL = 28672
RECFM = VB

File 2 format
Same as File 1

If record is on file 1 and record is not on file 2 Then
Output to file 3

Thanks in advance for any assistance,
Phillip

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

Post by Frank Yaeger » Fri Feb 25, 2011 11:06 pm

The maximum number of bytes DFSORT can sort (= compare) is around 4K. So you can't use DFSORT to do what you want.
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