IS [NOT] DISTINCT FROM Search Condition Support

The ANSI SQL search conditions IS DISTINCT FROM and IS NOT DISTINCT FROM are now supported in SAP Sybase IQ 16.0 SP2.

See this topic in the SAP Sybase IQ 16.0 SP2 documentation:

Search Conditions in Reference: Building Blocks, Tables, and Procedures

Related concepts
Read This First: Helpful Hints Before You Start Using SAP Sybase IQ 16