News
Abstract
New functions HASH_MD5, HASH_SHA1, HASH_SHA256, and HASH_SHA512 have been introduced for IBM i in 7.4.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Functional Enhancements > HASH Built-in function enhancements
In IBM i 7.4, the existing HASH function has been renamed to HASH_VALUES.
Any use of the HASH function as defined prior to IBM i 7.4 must be changed to use the renamed version of this function, HASH_VALUES.
Any use of the HASH function as defined prior to IBM i 7.4 must be changed to use the renamed version of this function, HASH_VALUES.
See the IBM i 7.4 Memorandum To Users (MTU) for details about this and other behavior changes: IBM i 7.4 MTU
The new HASH built-in functions are:
- HASH_MD5, HASH_SHA1, HASH_SHA256, and HASH_SHA512
- HASH is a synonym for HASH_MD5, if only one argument is passed
- Choose your hash function based upon algorithm or result size
See the SQL Reference for function details: HASH functions
[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"}]
Was this topic helpful?
Document Information
Modified date:
15 January 2020
UID
ibm11115613