ROW constructor is a complex function used to explicitly generate rows of values that can be assigned to fields in an output message.
A ROW consists of a sequence of named values. When assigned to a field reference it creates that sequence of named values as child fields of the referenced field. A ROW cannot be assigned to an array field reference.
SET OutputRoot.XML.Data = ROW('granary' AS bread, 'riesling' AS wine, 'stilton' AS cheese);produces:
<Data> <bread>granary</bread> <wine>riesling</wine> <cheese>stilton</cheese> </Data>
<Proof> <beer>5</beer> <wine>12</wine> <gin>40</gin> </Proof>the following ESQL:
SET OutputRoot.XML.Data = ROW(InputBody.Proof.beer, InputBody.Proof.wine AS vin, (InputBody.Proof.gin * 2) AS special);produces the following result:
<Data> <beer>5</beer> <vin>12</vin> <special>80</special> </Data>Because the values in this case are derived from field references that already have names, it is not necessary to explicitly provide a name for each element of the row, but you might choose to do so.
Related concepts
ESQL
Related tasks
Developing ESQL
Accessing the Environment tree
Related reference
Complex ESQL functions
LIST constructor function
ROW and LIST combined
ROW and LIST comparisons
Notices |
Trademarks |
Downloads |
Library |
Support |
Feedback
![]() ![]() |
ak05630_ |