Background documentationPredicate (predicate) Locate this document in the navigation structure


A predicate is specified in a WHERE clause in a statement which is "true", "false", or "undefined".

The result is generated by applying the predicate to a specific row in a result table or to a group of rows in a table that was formed by the GROUP clause.



Columns in a table with the same code attribute can be compared. Columns that have different code attributes such as ASCII and UNICODE can be compared. Columns with the code attribute ASCII or UNICODE can be compared with date values, time values or time stamp values.

LOB columns can only be used in the NULL predicate (null_predicate).

More Information

Table Expression