SYSCAT.PREDICATESPECS catalog view
Each row represents a predicate specification.
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| FUNCSCHEMA | VARCHAR (128) | Schema name of the function. | |
| FUNCNAME | VARCHAR (128) | Unqualified name of the function. | |
| SPECIFICNAME | VARCHAR (128) | Name of the function instance. | |
| FUNCID | INTEGER | Identifier for the function. | |
| SPECID | SMALLINT | Number of this predicate specification. | |
| CONTEXTOP | CHAR (8) | Comparison operator, one of the built-in relational operators (=, <, >, >=, and so on). | |
| CONTEXTEXP | CLOB (2M) | Constant, or an SQL expression. | |
| FILTERTEXT | CLOB (32K) | Y | Text of the data filter expression. |