WebSphere Message Brokers
File: ak05630_
Writer: Bill Oppenheimer

Reference topic

This build: July 31, 2007 21:32:21

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.XMLNS.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.XMLNS.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 overview
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2007Copyright IBM Corporation 1999, 2007. All Rights Reserved.
This build: July 31, 2007 21:32:21

ak05630_ This topic's URL is: