Compare two datasets. Compare the whole record
Posted: Fri Jun 12, 2009 4:25 pm
Hi,
I need some help two compare two datasets (Day 1 / Day 2).
The files are FB and 10300 bytes record length.
The records can be matched by key but I need to extract only those that are in Day 2 but not in Day 1 file and those that have changed in some part of the record.
I have found some ideas in this forum, but the only way that I have found to expand the comparision to the whole record is to declare th JOINKEYS to 10300.
It works with test files of 30 bytes but not with real files.
I receive a message like this "WER271A JOINKEYS STATEMENT: NUMERIC FIELD ERROR2".
If you can help with this or can suggest me a different tool that fit better with the request I will appreciate.
Thanks a lot for the help.
I need some help two compare two datasets (Day 1 / Day 2).
The files are FB and 10300 bytes record length.
The records can be matched by key but I need to extract only those that are in Day 2 but not in Day 1 file and those that have changed in some part of the record.
I have found some ideas in this forum, but the only way that I have found to expand the comparision to the whole record is to declare th JOINKEYS to 10300.
It works with test files of 30 bytes but not with real files.
I receive a message like this "WER271A JOINKEYS STATEMENT: NUMERIC FIELD ERROR2".
If you can help with this or can suggest me a different tool that fit better with the request I will appreciate.
Thanks a lot for the help.