| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Access to database in a procedure out of a compute module |
« View previous topic :: View next topic » |
| Author |
Message
|
| artykito |
 Posted: Wed Aug 24, 2011 12:52 am Post subject: Access to database in a procedure out of a compute module |
 |
|
Apprentice
Joined: 24 Jun 2010
Posts: 33
|
Hi all,
I want to know if it's possible to do what I want:
I need to do a few times the same INSERT into a database from differents Compute nodes.
I thought to do a procedure out of the compute modules in the .esql file, and do the insert through a CALL statement passing some parameters (the fields from the input message). The problem is that is necessary to declare the Data Source property in the Compute node, then I can't do a database statement out of a Compute module in the .esq file. The error I get when I tried that is obviously, "data source not found".
Do you know if there is a way to link the datasource with a procedure out of a compute module or must I to repeat my insert one for each compute module?
Thank you in advance! Regards |
|
| Back to top |
|
 |
| artykito |
| Posted: Wed Aug 24, 2011 1:22 am Post subject: |
|
|
Apprentice
Joined: 24 Jun 2010
Posts: 33
|
I found the solution. Only setting the data source name in the Compute nodes that calls to your function.
Thanks anyway! |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Aug 24, 2011 1:29 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
You need to put SOME kind of valid DSN (for the same database type - db2, oracle, etc) on any compute node that runs database statements in any way (procedure or not).
It doesn't have to be the database you are calling, however. |
|
| 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
|
|
|
|
