Cognos 10.2.2
I'm looking for a report studio function similar to Oracle's ORA_HASH.
Is there a function in report studio that will allow me to create a hash value?
What's a hash value? (Anyone that gives me an answer in £s per ounce will be made to stand in the naughty corner!)
Quote from: BigChris on 09 Jul 2018 09:30:29 AM
What's a hash value? (Anyone that gives me an answer in £s per ounce will be made to stand in the naughty corner!)
;D ;D ;D ;D ;D ;D ;D ;D ;D
A hash is, usually, a numeric value that encodes a string based on a seed value. The expression and seed should always resolve to the same value.
In this case I'd try to use the ORA_HASH from Oracle. What happens when you try to use it? Cognos will occasionally permit the use of native database function, so long as you are calling that particular database. If you're not on Oracle, what database is it?
what about md5 ()