Hash value in output

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dnat
Participant
Posts: 200
Joined: Thu Sep 06, 2007 2:06 am

Hash value in output

Post by dnat »

Hi,

I would like to output a key value(Like hash key) for the input which i send. For the same values i would need to get the same key values all the time.

For example

For the value "xyz, bg road" if a key is returned something like 9389494949, then everytime when i give the input the same key should be returned.

Is there any utility in datastage, parellel or server to achieve this?.

Even if it is in oracle or unix, it should be fine
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The Checksum() function should achieve this result for small enough strings. (There's also a Checksum stage but I can't recall whether this existed in version 7.)
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