Boolean Predicate

Description

A Boolean predicate returns the truth value of a Boolean expression.

Click here to navigate to the IBM DB2 docs page for this syntax.

Grammar Syntax

Sample Source Patterns

IBM DB2

Code 1

SELECT COLA FROM TBLAB WHERE COLA = COLX IS NOT TRUE;
SELECT COLA FROM TBLAB WHERE COLA = COLX IS NOT FALSE;
SELECT COLA FROM TBLAB WHERE COLA = COLX IS FALSE;
SELECT COLA FROM TBLAB WHERE COLA = COLX IS TRUE;

Snowflake

Code 1

SELECT COLA FROM TBLAB WHERE NOT COLA = COLX;
SELECT COLA FROM TBLAB WHERE COLA = COLX;
SELECT COLA FROM TBLAB WHERE NOT COLA = COLX;
SELECT COLA FROM TBLAB WHERE COLA = COLX;