| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Accessing DB from ESQL file |
« View previous topic :: View next topic » |
| Author |
Message
|
| sarathmattam |
 Posted: Wed Jul 02, 2014 10:19 pm Post subject: Accessing DB from ESQL file |
 |
|
Voyager
Joined: 05 Sep 2008
Posts: 94
|
Dear All,
This query is about accessing database from a standalone (which is not attached to any message flow)ESQL file.
My requirement is as below. I have a number of simple message flows
for eg : Mq Inout -- > Compute -- > MQ Output. From the compute node I need to access a set of ESQL functions defined in a librabry.
The library has just one ESQL file. Many of these functions access DB. So, in order to get this working, I always need to pass the schema name to the function. I am doing it through a reference to environment tree and though it works, I feel it has an impact on the performance. Now my query, is there a better way to do it ? When I define the schema name as a variable in the ESQL file, it is not accepting it.
Regards,
Sarath |
|
| Back to top |
|
 |
| Tibor |
| Posted: Thu Jul 03, 2014 5:46 am Post subject: |
|
|
Grand Master
Joined: 20 May 2001
Posts: 1033
Location: Hungary
|
Calling database *may* be a performance impact, using a schema name is unlikely.
It would be recommended checking it with some measures, e.g. switching the user trace on and analyzing the output. |
|
| Back to top |
|
|
| sarathmattam |
| Posted: Mon Jul 14, 2014 11:30 pm Post subject: |
|
|
Voyager
Joined: 05 Sep 2008
Posts: 94
|
Hi Tibor, Thank you. However, I couldn't get your point completely. Can you please elaborate ?
Regards,
Sarath |
|
| 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
|
|
|
|
