Basic Predicate

Description

A basic predicate compares two values or compares a set of values with another set of values.

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

Grammar Syntax

Note that there are alternative operators for <>, <= and >=.

Sample Source Patterns

IBM DB2

Code

SELECT COLA FROM TBLAB WHERE COLA ^= AValue;
SELECT COLA FROM TBLAB WHERE COLA ^< AValue;
SELECT COLA FROM TBLAB WHERE COLA !< AValue;
SELECT COLA FROM TBLAB WHERE COLA ^> AValue;
SELECT COLA FROM TBLAB WHERE COLA !> AValue;

Snowflake

Code

SELECT COLA FROM TBLAB WHERE COLA <> AValue;
SELECT COLA FROM TBLAB WHERE COLA >= AValue;
SELECT COLA FROM TBLAB WHERE COLA >= AValue;
SELECT COLA FROM TBLAB WHERE COLA <= AValue;
SELECT COLA FROM TBLAB WHERE COLA <= AValue;

Note that only the operators are transformed, since some of them are not supported in Snowflake, but there are other operators that do the same function.

The examples only contain those operators that must be changed.