CRC32 Value different from project to project

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
lenny
Participant
Posts: 17
Joined: Wed Nov 02, 2005 1:26 pm

CRC32 Value different from project to project

Post by lenny »

Hello,

I am using crc32 function to calculate row value for type2 changes.
I did crc32 on one data set in development project and used the same data set
in UAT to do crc32. I expected both the values to be same but they are different.

In short crc32 value in development is different from UAT for the same row

Thanks in advance

Regards
lenny
lenny
Participant
Posts: 17
Joined: Wed Nov 02, 2005 1:26 pm

Post by lenny »

sorry i forgot add my question.

why is it different from project to project?
lenny
DeepakCorning
Premium Member
Premium Member
Posts: 503
Joined: Wed Jun 29, 2005 8:14 am

Post by DeepakCorning »

As far as I know it should not be , check if there are some extra spaces or any extra characters in ur UAT data?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

It should not matter what the actual generated CRC value is, provided it remains consistent for all given values on any one platform.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

The mathematics of a CRC32 computation are bit-oriented so should not be different unless you are using different code. Are you certain your versions of DataStage are exactly identical?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Or different byte order, or different separator, or different column order, or maybe other differences; even the character order can be significant.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply