IBM Integration Bus, Version 10.0.0.17 Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS


Querying null values in a message in the MRM domain

You can use an ESQL statement to compare an element to NULL.

About this task

If you want to compare an element to NULL, code the statement:

IF InputRoot.MRM.Elem2.Child1 IS NULL THEN
   DO:
    -- more ESQL --
END IF;

If nulls are permitted for this element, this statement tests whether the element exists in the input message, or whether it exists and contains the MRM-supplied null value. The behavior of this test depends on the physical format:

If you want to determine if the field is missing, rather than present but with null value, you can use the ESQL CARDINALITY function.


ac06050_.htm | Last updated 2019-07-13 08:11:59