SYSCAT.DATAPARTITIONEXPRESSION catalog view

Each row represents an expression for that part of the table partitioning key.

Table 1. SYSCAT.DATAPARTITIONEXPRESSION Catalog View
Column Name Data Type Nullable Description
TABSCHEMA VARCHAR (128)   Schema name of the partitioned table.
TABNAME VARCHAR (128)   Unqualified name of the partitioned table.
DATAPARTITIONKEYSEQ INTEGER   Expression key part sequence ID, starting from 1.
DATAPARTITIONEXPRESSION CLOB (32K)   Expression for this entry in the sequence, in SQL syntax.
NULLSFIRST CHAR (1)  
  • N = Null values in this expression compare high
  • Y = Null values in this expression compare low