View previous topic :: View next topic |
Author |
Message |
surendar Beginner
Joined: 14 Apr 2006 Posts: 4 Topics: 1 Location: chennai
|
Posted: Wed Apr 19, 2006 2:35 am Post subject: File Compares |
|
|
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 |
|
![](templates/subSilver/images/spacer.gif) |
hariavinash Beginner
Joined: 21 Jan 2005 Posts: 52 Topics: 7
|
Posted: Wed Apr 19, 2006 3:51 am Post subject: |
|
|
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 |
|
![](templates/subSilver/images/spacer.gif) |
surendar Beginner
Joined: 14 Apr 2006 Posts: 4 Topics: 1 Location: chennai
|
Posted: Wed Apr 19, 2006 4:18 am Post subject: |
|
|
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](images/smiles/icon_neutral.gif) |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
kolusu Site Admin
![Site Admin Site Admin](images/ranks/adminpic.jpg)
Joined: 26 Nov 2002 Posts: 12367 Topics: 75 Location: San Jose
|
Posted: Wed Apr 19, 2006 7:41 am Post subject: |
|
|
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 |
|
![](templates/subSilver/images/spacer.gif) |
|
|