Default language.

Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Load for Db2 13.1.

VALUE/COALESCE/IF NULL

The VALUE function argument list must have a homogeneous data type. That is, if the first argument is SMALLINT, the rest of the arguments must be of type SMALLINT.

A minimum of two expressions and max of 255 expressions can be specified. The first argument determines the data type of the result and therefore cannot be a constant.

VALUE.png

Important

The function returns a non-null value of the first non-null expression and of the same data type.

The result can be null only if all arguments can be null. The result is null only if all arguments are null.

The argument's data types must be the same. If one is SMALLINT, all other arguments must be SMALLINT. If one is a decimal then all must be decimal but can have different precisions and scale; the largest precision and scale will be selected as the final result.


Related topics

Functions-that-the-BMC-AMI-Utilities-SQL-language-supports

Features-that-the-BMC-AMI-Utilities-SQL-language-supports


 

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