| Author |
Message
|
| ravi.cloud2006 |
 Posted: Thu Apr 23, 2015 3:46 am Post subject: Join in ESQL |
 |
|
Newbie
Joined: 19 Feb 2014
Posts: 6
|
Hi ,
I am trying to Join two Array in esql.
DECLARE LinkedACResponse REFERENCE TO Environment.Variables.LinkedACResponse.NS:LINKED_ACC_RESPONSE.BODY;
SET Environment.Variables.Accounts.ALLOWEDACCOUNTS[] = SELECT WS.ACCOUNTNUM,WS.ACCOUNTTITLE FROM table1 AS WS.
SET Environment.Variables.ActiveAccounts [] = SELECT CIT.* FROM Environment.Variables.Accounts.ALLOWEDACCOUNTS[] AS CIT,LinkedACResponse.{NS}:ACCOUNT_DETAILS_BODY[] AS LIN
WHERE CIT.ACCOUNTNUM = LIN.{NS}:ACCOUNT_NO AND LIN.{NS}:ACCOUNT_STATUS = 'AC';
Above join is giving me empty row.
Is there any way to do this?
Thanks, |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Thu Apr 23, 2015 5:07 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
ESQL doesn't have arrays. Those are siblings of a common root node.
When working with message trees under the Environment, you need to make sure that there is an appropriate parser associated with them. |
|
| Back to top |
|
|
| ravi.cloud2006 |
| Posted: Thu Apr 23, 2015 5:17 am Post subject: |
|
|
Newbie
Joined: 19 Feb 2014
Posts: 6
|
| Can we join two siblings from environment? |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Apr 23, 2015 5:25 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| ravi.cloud2006 wrote: |
| Can we join two siblings from environment? |
Did you as mqjeff said assign a parser to the branch of the environment tree holding the siblings? 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| ravi.cloud2006 |
| Posted: Thu Apr 23, 2015 5:30 am Post subject: |
|
|
Newbie
Joined: 19 Feb 2014
Posts: 6
|
| Both Are xml ,do i need assign explicitly? |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Apr 23, 2015 5:43 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| ravi.cloud2006 wrote: |
| Both Are xml ,do i need assign explicitly? |
Yes you do. There is no default parser on the Environment tree.
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| ravi.cloud2006 |
| Posted: Thu Apr 23, 2015 6:40 am Post subject: |
|
|
Newbie
Joined: 19 Feb 2014
Posts: 6
|
Thanks for your response..  |
|
| Back to top |
|
|
|
|
