| Author |
Message
|
| nab054371 |
 Posted: Wed Jan 03, 2007 12:50 pm Post subject: Database SQL issue |
 |
|
Disciple
Joined: 15 Nov 2006
Posts: 173
|
SQL Statement:
SET OutputRoot.XML.test = THE(SELECT T.* FROM Database.USER_TBL AS T);
Table USER_TBL has 3 columns and 50 rows. However my output message looks <test/>
I would have expected it to spit out three columns from the table inside of <test></test> ? |
|
| Back to top |
|
 |
| pathipati |
| Posted: Wed Jan 03, 2007 5:35 pm Post subject: |
|
|
Master
Joined: 03 Mar 2006
Posts: 296
|
|
| Back to top |
|
|
| nab054371 |
| Posted: Wed Jan 03, 2007 8:03 pm Post subject: |
|
|
Disciple
Joined: 15 Nov 2006
Posts: 173
|
|
| Back to top |
|
|
| elvis_gn |
| Posted: Wed Jan 03, 2007 9:54 pm Post subject: Re: Database SQL issue |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi nab054371,
| nab054371 wrote: |
| SET OutputRoot.XML.test = THE(SELECT T.* FROM Database.USER_TBL AS T); |
THE SELECT ITEM
This would ofcourse picked the first...hope thats what u want too.
Regards. |
|
| Back to top |
|
|
| AkankshA |
| Posted: Thu Jan 04, 2007 1:09 am Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
Try giving the column names in select
i.e.
SET OutputRoot.XML.test = THE(SELECT T.a, T.b, T.c FROM Database.USER_TBL AS T);
It should work. |
|
| Back to top |
|
|
| nab054371 |
| Posted: Thu Jan 04, 2007 5:20 am Post subject: |
|
|
Disciple
Joined: 15 Nov 2006
Posts: 173
|
| I know that works,I am testing T.* as specified in MQ Manuals |
|
| Back to top |
|
|
|
|
