| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| How to store (a list of) data in a tree from a DB? |
« View previous topic :: View next topic » |
| Author |
Message
|
| chocobo0079 |
 Posted: Thu May 29, 2008 3:37 am Post subject: How to store (a list of) data in a tree from a DB? |
 |
|
Newbie
Joined: 29 May 2008
Posts: 4
|
Hi, I am new for WMB, using 6.0.2
I would like to store data from ESQL SELECT statement to a tree, can I do the follow even I don't have the XML schema? 
SET OutputRoot.(MRM/XMLNS/...).Temp.Array[]=
(SELECT T.A as A, T.B as B from DB as T);
I know it is stupid to do so, but I want to know what should I do to store the data from a DB so that I can call the data back as follow:
OutputRoot.(MRM/XMLNS/...).Temp.Array[1].A;
OutputRoot.(MRM/XMLNS/...).Temp.Array[2].B ....
Since my target is to compare two DBs, one is DB1 and the other is a list of data response from a external web service which call DB2.
So I want to store DB1 in a tree and compare the list of data from DB2.
Thanks for help!!  |
|
| Back to top |
|
 |
| mgk |
| Posted: Thu May 29, 2008 3:48 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
ESQL will compare lists (trees) very easily using any of the "equality operators". So you can select from the DBs into the LocalEnv and then compare the lists...
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| chocobo0079 |
| Posted: Thu May 29, 2008 5:40 pm Post subject: |
|
|
Newbie
Joined: 29 May 2008
Posts: 4
|
thanks for help mgk!
you saved me once before this from your reply to other topic  |
|
| 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
|
|
|
|
