| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Appending to the list |
« View previous topic :: View next topic » |
| Author |
Message
|
| prabuk |
 Posted: Wed Apr 02, 2003 12:24 pm Post subject: Appending to the list |
 |
|
Novice
Joined: 14 Mar 2003
Posts: 19
Location: JerseyCity, NJ
|
Hi,
I want to append to the list, by using the following statement, it will always overwrite the list.
[code][size=7][color=brown]SET OutputRoot.XML.rules."domains"[] = (SELECT T.ID, T.TAG, T.VALUE FROM Database.domains AS T WHERE T.ID = domId AND T.TAG = domTagName);[/color][/size][/code]
Is there any union kind operators in ESQL? with which we could do something like this,
[code][size=7][color=brown]SET OutputRoot.XML.rules."domains"[] = (SELECT T.ID, T.TAG, T.VALUE FROM OutputRoot.XML.rules."domains"[]) UNION (SELECT T.ID, T.TAG, T.VALUE FROM Database.domains AS T WHERE T.ID = domId AND T.TAG = domTagName);[/color][/size][/code]
Thanks
Prabu |
|
| Back to top |
|
 |
| prabuk |
| Posted: Wed Apr 02, 2003 1:43 pm Post subject: Appending to the list |
|
|
Novice
Joined: 14 Mar 2003
Posts: 19
Location: JerseyCity, NJ
|
Hi,
If not UNION, anybody know of any workaround to append rows to an existing list or concatenating two lists into one?
Tx
Prabu |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
