DB2 Scalar functions - Partitioning scalar functions - www.cadcobol.com.br


Volta ao Menu das scalar functions Volta ao Menu Principal

Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

DB2 Scalar functions - Partitioning scalar functions
Function Description
DATAPARTITIONNUM Returns the sequence number (SYSDATAPARTITIONS.SEQNO) of the data partition in which the row resides.
The argument is any column name within the table.
DBPARTITIONNUM Returns the database partition number of the row. The argument is any column name within the table.
HASH Returns the 128-bit, 160-bit, 256-bit or 512-bit hash of the input data.
HASH4 Returns the 32-bit hash of the input data.
HASH8 Returns the 64-bit hash of the input data.
HASHEDVALUE Returns the distribution map index (0 to 32767) of the row.
The argument is a column name within a table.

© Copyright IBM Corp.