MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

File Compares

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities
View previous topic :: View next topic  
Author Message
surendar
Beginner


Joined: 14 Apr 2006
Posts: 4
Topics: 1
Location: chennai

PostPosted: Wed Apr 19, 2006 2:35 am    Post subject: File Compares Reply with quote

We are using ICETOOL to convert the three digit code to four digit in database or a flat file processing.

Let me explain the scenario..
The fourth digit we are including is a check digit so we manually give the corresponding four digit for the particular three digit value.
ICETOOL performs it by changing the three digit whereever in the file to four digit.

But for testing purpose and the input/Output file is a Huge one, we are not in a position to compare comfortably.

Do you have anyother option to compare these files once after code is converted.

Using FILEAID i tried to compare, but it is difficult to find the missing records and wrong ones.
Back to top
View user's profile Send private message
hariavinash
Beginner


Joined: 21 Jan 2005
Posts: 52
Topics: 7

PostPosted: Wed Apr 19, 2006 3:51 am    Post subject: Reply with quote

You can use SUPERC utility to compare.

or alternatively
Code:

//USERID JOB 00000001,'IEBCOMPARE',NOTIFY=&SYSUID,CLASS=A
//SUPERC  EXEC PGM=ISRSUPC,
//            PARM=(DELTAL,LINECMP,
//            '',
//            '')
//NEWDD  DD DSN=NEW.DATASET.NAME,
//          DISP=SHR
//OLDDD  DD DSN=OLD.DATASET.NAME,
//          DISP=SHR
//OUTDD  DD SYSOUT=*


For testing purposes can you not make a smaller version of the input/output file and run it?

Cheers
Avi
Back to top
View user's profile Send private message
surendar
Beginner


Joined: 14 Apr 2006
Posts: 4
Topics: 1
Location: chennai

PostPosted: Wed Apr 19, 2006 4:18 am    Post subject: Reply with quote

Yeah,

Thats the problem. Because of big big files with millions of records i need a suitable way to test it.
Am not unit testing it. Neutral
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12367
Topics: 75
Location: San Jose

PostPosted: Wed Apr 19, 2006 7:41 am    Post subject: Reply with quote

surendar,

Code a sample job with few records and check if the results are correct. Also as hariavinash mentioned you can run superC in batch mode to compare the results just on the field you have changed.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group