Skip to Content

Default language.

Information
Limited support BMC 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.

NULLIF(fieldSelection)

NULLIF(fieldSelection) conditionally specifies whether a table column should receive the input data value (if provided) or a Db2 null value. You cannot specify NULLIF clauses for columns that are defined as NOT NULL.

The condition that you specify uses the same syntax as the field selection specified on a WHEN clause. For more information, see the field selection syntax diagram.

Related topics

Field-specification

INTO-TABLE-options

WHEN-and-WHERE 

 

 

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

BMC AMI Load for Db2 12.1