The HASH function returns the partition number of a set of values. Also see the PARTITION function. For more information about partition numbers, see the DB2(R) Multisystem book.
The result of the function is a large integer with a value between 0 and 1023.
If any of the arguments are null, the result is zero. The result cannot be null.
SELECT HASH(EMPNO, LASTNAME) FROM EMPLOYEE
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.