Null Predicate

Description

The NULL predicate tests for null values.

NULL Predicate is functionally equivalent to Snowflake.

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

Grammar Syntax

Sample Source Patterns

IBM DB2

Code

select * 
from i 
where col1 is not null;

select * 
from i 
where col2 is null;

Snowflake

Code

select * 
from i 
where col1 is not null;

select * 
from i 
where col2 is null;