| Author |
Message
|
| sasad |
 Posted: Thu Sep 18, 2014 1:15 am Post subject: Can we do DB call in Custom ESQL code |
 |
|
Acolyte
Joined: 30 Apr 2014
Posts: 67
|
Hi everyone,
I have following message flow,
TCP/IP Input => Mapping Node => MQInput => MQGet => TCP/IP Output
I get Model1 as request and then I need to transform it to Model2. I am using mapping node for thsi transformation. There is one field in Output model whose value will be fetched from DB using Input field. I don't know if this can be done in Mapping node or not.
Can we do db call in Custom ESQL code?
Can we call SQL server procedure in mapping node?
Experts Please suggest any solution!
thanks!! |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Thu Sep 18, 2014 4:29 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
yes to both.
Read up in the infocenter and look at the training videos on the IBM site.
Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| sasad |
| Posted: Thu Sep 18, 2014 6:08 am Post subject: |
|
|
Acolyte
Joined: 30 Apr 2014
Posts: 67
|
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Sep 18, 2014 6:48 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Then why did you ask:
| sasad wrote: |
| Can we do db call in Custom ESQL code? |
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Sep 18, 2014 9:22 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
And thank you for specifying that with Custom ESQL you meant ESQL called from a map... and not custom code you wrote in ESQL for an ESQL node....
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| sasad |
| Posted: Thu Sep 18, 2014 9:54 pm Post subject: |
|
|
Acolyte
Joined: 30 Apr 2014
Posts: 67
|
Sorry, I didn't checked info center before asking question.
But I mentioned that I am using Mapping node for transformation. Anyways thanks for reply. |
|
| Back to top |
|
|
|
|
