Using the Relational Data Framework › Use IN Predicates in WHERE Clauses › Using Boolean Expressions

Previous Topic: Comparing One or More Values

Next Topic: Using LIKE Predicates in WHERE Clauses

Using Boolean Expressions

If you want to, you can combine predicates into compound Boolean expressions. For example, you can create a WHERE clause like the following:

"WHERE (NAME = 'IMS' AND RECOV_PROC <> FIXCICS)",
  "OR DESIRED_STATE = 'DOWN'",
    "AND CURRENT_STATE IN ('UP','UNKNOWN')"

The CA OPS/MVS product supports up to three nested levels of Boolean expressions in parentheses.