| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Accesing DB from Broker |
« View previous topic :: View next topic » |
| Author |
Message
|
| learning_WMB |
 Posted: Fri Aug 17, 2007 1:10 pm Post subject: Accesing DB from Broker |
 |
|
Newbie
Joined: 17 Aug 2007
Posts: 1
|
Hello,
I am broker newbie, i've installed my broker and toolkit, configured DB and everything.
Can anyone tell me how do i make a flow as simple as accessing(quering) database.
If I have a table of 2 columns Emp ID and Emp Name.
How do i query database on base of EMP ID(Hardcoded) and get EMP NAME?
Thanks in advance |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Fri Aug 17, 2007 2:38 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You will not get training here.
If you need training, and you do, then you should be prepared to pay for it.
If you can not afford it, then you should be prepared to spend lots of your own time reading, thinking, and learning.
If your employer refuses to a) pay for training, b) pay you while you spend that time learning the product, then obviously your employer does not actually want you to use WMB.
Happy Reading.
And to answer your question more directly - you perform a database query by writing a message flow that queries a database.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| mymq |
| Posted: Sat Aug 18, 2007 4:32 pm Post subject: |
|
|
Centurion
Joined: 01 Mar 2007
Posts: 101
Location: US-Greenwille
|
1) Create a DSN (Data source name) for your database.
2) Attach the DSN with broker using "mqsisetdbparms"
3) Specify the DSN in your Compute Node.
4) Then u can write the SQL in your ESQL code.
Enjoy!!!
_________________
--SRK-- |
|
| Back to top |
|
|
| datspats |
| Posted: Sun Aug 19, 2007 9:40 pm Post subject: |
|
|
Voyager
Joined: 12 Apr 2007
Posts: 80
Location: Mumbai
|
If DB is oracle make sure you use, MQSeries Datadirect Tech. driver for oracle, with option set Enable SQL Describe Params.
Also set mqsisetdbparams from command console
regards, |
|
| 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
|
|
|
|
