Table 114. OBJCAT.PREDICATESPECS Catalog View
Column Name | Data Type | Nullable | Description |
---|---|---|---|
FUNCSCHEMA | VARCHAR(128) |
| Qualified name of function. |
FUNCNAME | VARCHAR(18) |
| |
SPECIFICNAME | VARCHAR(18) |
| The name of the function instance. |
FUNCID | INTEGER |
| Function ID. |
SPECID | SMALLINT |
| ID of this predicate specification. |
CONTEXTOP | CHAR(8) |
| Comparison operator is one of the built-in relational operators (=,<,>=, etc.). |
CONTEXTEXP | CLOB(32K) |
| Constant, or an SQL expression. |
FILTERTEXT | CLOB(32K) | Yes | Text of data filter expression. |