WebSphere Message Brokers
File: ak05880_
Writer: Bill Oppenheimer

Reference topic

This build: July 31, 2007 21:32:35

NULLIF function

NULLIF is a miscellaneous function that returns a NULL value if the arguments are equal.

Syntax

The NULLIF function returns a NULL value if the arguments are equal; otherwise, it returns the value of the first argument. The arguments must be comparable. The result of using NULLIF(e1,e2) is the same as using the expression:
CASE WHEN e1=e2 THEN NULL ELSE e1 END

When e1=e2 evaluates to unknown (because one or both of the arguments is NULL), NULLIF returns the value of the first argument.

Related concepts
ESQL overview
Related tasks
Developing ESQL
Related reference
Syntax diagrams: available types
Miscellaneous ESQL functions
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2007Copyright IBM Corporation 1999, 2007. All Rights Reserved.
This build: July 31, 2007 21:32:35

ak05880_ This topic's URL is: