| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| configuring database dynamically to message broker |
« View previous topic :: View next topic » |
| Author |
Message
|
| vickas |
 Posted: Mon Sep 30, 2013 7:58 pm Post subject: configuring database dynamically to message broker |
 |
|
Centurion
Joined: 18 Aug 2013
Posts: 126
|
How do i configure database dynamically to the message broker ?
for eg, there are 10 databases n i need to retrieve some data and depending upon that i will propagate to different message flows/subflows..
In this scenerio , where each time i access different databases(depending upon the input i recieve) how do i configure ? |
|
| Back to top |
|
 |
| Simbu |
| Posted: Mon Sep 30, 2013 8:59 pm Post subject: Re: configuring database dynamically to message broker |
|
|
Master
Joined: 17 Jun 2011
Posts: 289
Location: Tamil Nadu, India
|
| vickas wrote: |
| How do i configure database dynamically to the message broker ? |
| Quote: |
| If you have user databases, you must configure them before you can access them from your message flow |
| vickas wrote: |
for eg, there are 10 databases n i need to retrieve some data and depending upon that i will propagate to different message flows/subflows..
In this scenerio , where each time i access different databases(depending upon the input i recieve) how do i configure ? |
Its depend on the types of the database you are using and what type of node you are using to achieve your requirement.
Say for example, you can access multiple databases in a ComputeNode only if the Databases are at same level,type.
Look at these tech notes, you will get some idea.
http://www-01.ibm.com/support/docview.wss?uid=swg21449152
http://www-01.ibm.com/support/docview.wss?uid=swg21444992 |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Tue Oct 01, 2013 3:20 am Post subject: Re: configuring database dynamically to message broker |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| Simbu wrote: |
| vickas wrote: |
| How do i configure database dynamically to the message broker ? |
| Quote: |
| If you have user databases, you must configure them before you can access them from your message flow |
| vickas wrote: |
for eg, there are 10 databases n i need to retrieve some data and depending upon that i will propagate to different message flows/subflows..
In this scenerio , where each time i access different databases(depending upon the input i recieve) how do i configure ? |
Its depend on the types of the database you are using and what type of node you are using to achieve your requirement.
Say for example, you can access multiple databases in a ComputeNode only if the Databases are at same level,type.
Look at these tech notes, you will get some idea.
http://www-01.ibm.com/support/docview.wss?uid=swg21449152
http://www-01.ibm.com/support/docview.wss?uid=swg21444992 |
Simbu - I think what you mean to say is the OP should follow the documentation:
| Quote: |
The next example shows the use of calculated data source, schema, and table names:
-- Declare variables to hold the data source, schema and table names
-- and set their default values
DECLARE Source CHARACTER 'Production';
DECLARE Schema CHARACTER 'db2admin';
DECLARE Table CHARACTER 'DynamicTable1';
-- Code which calculates their actual values comes here
-- Update rows in the table
UPDATE Database.{Source}.{Schema}.{Table} AS R SET Value = 0; |
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| 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
|
|
|
|
