To set a value of an element in an output message, you normally code an ESQL statement similar to the following:
SET OutputRoot.MRM.Elem2.Child1 = 'xyz';
or its equivalent statement:
SET OutputRoot.MRM.Elem2.Child1 VALUE = 'xyz';
If you set the element to a non-null value, these two statements give identical results. However, if you want to set the value to null, these two statements do not give the same result:
SET OutputRoot.MRM.Elem2.Child1 = NULL;
The content of the output bit stream depends on the physical format:
This is called implicit null processing.
SET OutputRoot.MRM.Elem2.Child1 VALUE = NULL;
This is called explicit null processing.
Setting a complex element to NULL deletes that element and all its children.
Related concepts
Message flows
ESQL
Message modeling
Custom wire format - NULL handling
XML wire format - NULL handling
Tagged/delimited string format - NULL handling
Related tasks
Querying null values in a message in the MRM domain
Designing a message flow
Defining message flow content
Managing ESQL files
Developing message models
Related reference
Compute node
Database node
Filter node
ESQL
SET statement
Notices |
Trademarks |
Downloads |
Library |
Support |
Feedback
![]() ![]() |
ac06060_ |