| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| JOIN IN ESQL |
« View previous topic :: View next topic » |
| Author |
Message
|
| tosaurav |
 Posted: Thu Mar 01, 2007 10:03 am Post subject: JOIN IN ESQL |
 |
|
Acolyte
Joined: 16 Jan 2007
Posts: 62
|
I want to run SELECT query from compute node to Oracle database.Query has outer join.Want to know how to write in esql.
Query is
SELECT B.ITEM, nvl(B.ITEMDESCEN, ''), nvl(A.Qty, '2'), nvl(A.InvoiceNo, ''), nvl(A.InvoiceText, '') FROM Database.Invoice AS A, Database.Item AS B WHERE B.itemKey = A.Invoice_Item_key(+) |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu Mar 01, 2007 10:09 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You can select from more than one datasource or message tree.
select a.*, b.* from Database.MYDB as a, InputRoot.XMLNS as B;
select a.*, b.* from Database.MYDB as a, Database.MYDB2 as B;
select a.*, b.* from InputRoot.XMLNS as b, Environment.Variables.OldMessageTree.XMLNS as b;
There are some rules about whether you have to select from message trees first or databases first when you are mixing the two.
But of course, you've already seen that in the documentation.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| tosaurav |
| Posted: Thu Mar 01, 2007 10:16 am Post subject: |
|
|
Acolyte
Joined: 16 Jan 2007
Posts: 62
|
| But my concern is join and nvl function. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Mar 01, 2007 10:18 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
|
| Back to top |
|
|
| au@kosa |
| Posted: Thu Mar 01, 2007 10:19 pm Post subject: |
|
|
Centurion
Joined: 04 Jan 2007
Posts: 103
Location: pune
|
|
| Back to top |
|
|
| au@kosa |
| Posted: Thu Mar 01, 2007 10:34 pm Post subject: |
|
|
Centurion
Joined: 04 Jan 2007
Posts: 103
Location: pune
|
you can use 'COALESCE function' in ESQL as an alternative of NVL in Oracle query
_________________
Regards,
au@kosa
IBM Certified SOA Solution Designer/Associate |
|
| 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
|
|
|
|
