Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
SELECT statementUse the SELECT statement to retrieve values from a database or from an SPL or collection variable. A SELECT operation is called a query.
WHERE clause of SELECTThe WHERE clause can specify join conditions for HCL OneDB™-extension joins, post-join filters for ANSI-compliant joins, and for search criteria on data values.
Using a Condition in the WHERE Clause
Using IS NULL and IS NOT NULL Conditions

Using IS NULL and IS NOT NULL Conditions

The IS NULL condition is satisfied if the specified column contains a NULL value, or if the specified expression evaluates to NULL.

If you use the IS NOT NULL predicate, the condition is satisfied when the column contains a value that is not NULL, or when the expression does not evaluate to NULL. The following example selects the order numbers and customer numbers for which the order has not been paid:

SELECT order_num, customer_num FROM orders
   WHERE paid_date IS NULL;

For a complete description of the IS NULL and IS NOT NULL operators, see the IS NULL and IS NOT NULL Conditions.