Example of HASH with DB2^® Multisystem

 

Use the HASH function to determine what the partitions should be if the partitioning key is composed of EMPNO and LASTNAME.

• The query returns the partition number for every row in EMPLOYEE. SQL statement:

  SELECT HASH(EMPNO, LASTNAME)
     FROM CORPDATA.EMPLOYEE

  OPNQRYF command:

  OPNQRYF FILE((CORPDATA/EMPLOYEE))
          FORMAT(FNAME)
          MAPFLD((HASH '%HASH(1/EMPNO, 1/LASTNAME)'))

 

Parent topic:

HASH with DB2 Multisystem