ROW constructor function

ROW constructor is a complex function used to explicitly generate rows of values that can be assigned to fields in an output message.

Syntax

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.

Examples

Example 1

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>

Example 2

Given the following XML input message body:
<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