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
Hash value in output
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.