CONNX Data Integration Suite 14.8.0 | Reference Guide | SQL Grammar | SQL Language Elements | Predicates | Predicates Overview
 
Predicates Overview
A predicate is a tri-state (true, false, unknown) Boolean expression. Predicates are composed of a search term contained within a search expression.
A predicate can take one of six forms:
*EXISTS
*COMPARE
*BETWEEN
*IN
*LIKE
*NULL
See the next chapters in this topic for additional information about each predicate.