Compare data from two files with utility



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Compare data from two files with utility

Postby rahul_phaltan » Mon Jul 19, 2010 3:51 pm

I have 2 files,
File 1 – Control file (with only one record)
Data –
0000319072010

File 2 – Main file
Data –
000000000000000019072010 (Header)
123123231
123123123
123123123
999999999999999999900003 (Trailer)

I need to compare these two files if date from File 1 is equal to date from File 2 – ‘19072010’
And count from file1 is equal to count from file 2 – ‘00003’

If the date and count is matching, process the file.
If not matching, show an error message.
rahul_phaltan
 
Posts: 1
Joined: Mon Jul 19, 2010 3:39 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Compare data from two files with utility

Postby Frank Yaeger » Mon Jul 19, 2010 9:05 pm

process the file.


Process the file how? Copy it? Sort it? Something else?

If not matching, show an error message.


What error message?

What is the RECFM and LRECL of each input file? What is the starting position, length and format of each relevant field?
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
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post