Oninit Logo
The Down System Specialists
+1-913-674-0360
+44-2081-337529
Partnerships Contact
Finderr

-293 IS [NOT] NULL predicate may be used only with simple

columns.

The test for a null value can be applied only to a column name (not to a subscripted character column or an expression, for example).

Review the use of these keywords in the WHERE clause and in any CASE statements.

This message does not apply to 8.21 and later 8.x database servers, which allow expressions as arguments of the IS [NOT] NULL operator.