WebSphere Message Brokers
File: ak05650_
Writer: Bill Oppenheimer

Reference topic

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

ROW and LIST combined

ROW and LIST combined form a complex function.

A ROW might validly be an element in a LIST. For example:
SET OutputRoot.XMLNS.Data.Country[] =
         LIST{ROW('UK' AS name,'pound' AS currency),
              ROW('US' AS name, 'dollar' AS currency),		
                                 'default'};
produces the following result:
<Data>
   <Country>
      <name>UK</name>
      <currency>pound</currency>
   </Country>
   <Country>
      <name>US</name>
      <currency>dollar</currency>
   </Country>
   <Country>default</Country>
</Data>

ROW and non-ROW values can be freely mixed within a LIST.

A LIST cannot be a member of a ROW. Only named scalar values can be members of a ROW.

Related concepts
ESQL overview
Related tasks
Developing ESQL
Accessing the Environment tree
Related reference
Complex ESQL functions
ROW constructor function
LIST constructor function
ROW and LIST comparisons
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:22

ak05650_ This topic's URL is: