NULL/NOT NULL predicate


If you are using the NULL/NOT NULL predicate, you must ensure that the underlying column has the NULL attribute defined.

Example

The following expression causes a syntax error if column 'COL1' was defined as NOT NULL:

COL1 IS NOT NULL

SQL statements that are ordinarily coded using the IBM MOD function must instead use the operator // (double forward slash ) as a substitute. 


Example

Instead of entering the following WHERE clause: 

MOD(DAYS(CURRENT DATE), 2) = 1

enter 

WHERE DAYS(CURRENT DATE) // 2 = 1

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*