WebSphere Message Broker, Version 8.0.0.7 Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS

See information about the latest product version

COALESCE function

COALESCE is a miscellaneous function that lets you provide default values for fields.

Syntax

Read syntax diagramSkip visual syntax diagram
                .-,------------.      
                V              |      
>>-COALESCE--(----source_value-+--)----------------------------><

The COALESCE function evaluates its parameters in order and returns the first one that is not NULL. The result is NULL if, and only if, all the arguments are NULL. The parameters can be of any scalar type, but they need not all be of the same type.

Use the COALESCE function to provide a default value for a field, which might not exist in a message. For example, the expression:
COALESCE(Body.Salary, 0)
returns the value of the Salary field in the message if it exists, or 0 (zero) if that field does not exist.
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2016Copyright IBM Corporation 1999, 2016.

        
        Last updated:
        
        Last updated: 2016-05-23 14:47:14


Reference topicReference topic | Version 8.0.0.7 | ak05870_