SYSCAT.DATAPARTITIONEXPRESSION catalog view
Each row represents an expression for that part of the table partitioning key.
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) |
|