The GET_HASH_VALUE function provides the capability to compute a hash value for a given string.
EXECUTE privilege on the DBMS_UTILITY module.
SELECT DBMS_UTILITY.GET_HASH_VALUE('Peter',100,1024) AS HASH_VALUE FROM SYSIBM.SYSDUMMY1@
SELECT DBMS_UTILITY.GET_HASH_VALUE('Mary',100,1024) AS HASH_VALUE FROM SYSIBM.SYSDUMMY1@
SELECT DBMS_UTILITY.GET_HASH_VALUE('Peter',100,1024) AS HASH_VALUE FROM SYSIBM.SYSDUMMY1
HASH_VALUE
--------------------
343
1 record(s) selected.
SELECT DBMS_UTILITY.GET_HASH_VALUE('Mary',100,1024) AS HASH_VALUE FROM SYSIBM.SYSDUMMY1
HASH_VALUE
--------------------
760
1 record(s) selected.