HASH

The HASH function returns the partition number of a set of values.

Read syntax diagramSkip visual syntax diagramHASH(,expression)

Also see HASHED_VALUE. For more information about partition numbers, see the DB2® Multisystem topic collection.

expression
An expression that returns a value of any built-in data type except date, time, timestamp, floating-point, XML, or DataLink values.

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.

Example

  • Use the HASH function to determine what the partitions would be if the partitioning key was composed of EMPNO and LASTNAME. This query returns the partition number for every row in EMPLOYEE. 
      SELECT HASH(EMPNO, LASTNAME)
    FROM EMPLOYEE