Author |
Message
|
rajesht1 |
Posted: Tue Oct 12, 2010 6:39 am Post subject: Database access |
|
|
Novice
Joined: 23 Jun 2010 Posts: 21
|
Can I access two database in a compute.If possible how ,can any one clear me about this .  |
|
Back to top |
|
 |
mqjeff |
Posted: Tue Oct 12, 2010 6:49 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008 Posts: 17447
|
You can access two separate databases from the same compute node.
They must both be of the same database type - Db2, Oracle, etc.
You are asking basic, simple and easy questions to answer on your own.
This is not a training forum or a place to get easy answers. Please try harder. |
|
Back to top |
|
 |
rajesht1 |
Posted: Wed Oct 13, 2010 2:33 am Post subject: |
|
|
Novice
Joined: 23 Jun 2010 Posts: 21
|
But in the compute node properties we can give only one Data Source Name.How the other database is accessed.............. |
|
Back to top |
|
 |
mqjeff |
Posted: Wed Oct 13, 2010 2:50 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008 Posts: 17447
|
The other database is accessed using the method described in the documentation. |
|
Back to top |
|
 |
rajesht1 |
Posted: Wed Oct 13, 2010 6:30 am Post subject: |
|
|
Novice
Joined: 23 Jun 2010 Posts: 21
|
which document? can u send me the link.Thanks for all your help |
|
Back to top |
|
 |
mqjeff |
Posted: Wed Oct 13, 2010 6:37 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008 Posts: 17447
|
If I send you the link, you won't learn how to find it yourself. |
|
Back to top |
|
 |
rajesht1 |
Posted: Wed Oct 13, 2010 6:39 am Post subject: |
|
|
Novice
Joined: 23 Jun 2010 Posts: 21
|
After all my ground work I am putting this question before you.So could you please send me the link please................ |
|
Back to top |
|
 |
Vitor |
Posted: Wed Oct 13, 2010 6:56 am Post subject: |
|
|
 Grand High Poobah
Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA
|
rajesht1 wrote: |
After all my ground work I am putting this question before you.So could you please send me the link please................ |
It's at the top of this page, marked "InfoCneter"  _________________ Honesty is the best policy.
Insanity is the best defence. |
|
Back to top |
|
 |
rajesht1 |
Posted: Wed Oct 13, 2010 7:03 am Post subject: |
|
|
Novice
Joined: 23 Jun 2010 Posts: 21
|
can u please suggest me in the search option what I have to entered............  |
|
Back to top |
|
 |
mqjeff |
Posted: Wed Oct 13, 2010 7:04 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008 Posts: 17447
|
Vitor wrote: |
rajesht1 wrote: |
After all my ground work I am putting this question before you.So could you please send me the link please................ |
It's at the top of this page, marked "InfoCneter"  |
Aside from being spelled wrong, the link at the top of this page points to the MQ V6 InfoCenter, not the Broker v7 InfoCenter.
But going to the main page for Broker on IBM's website will easily lead someone to the Broker v7 Information Center. |
|
Back to top |
|
 |
WMBDEV1 |
Posted: Wed Oct 13, 2010 7:46 am Post subject: |
|
|
Sentinel
Joined: 05 Mar 2009 Posts: 888 Location: UK
|
rajesht1 wrote: |
can u please suggest me in the search option what I have to entered............  |
Try something crazy like "Accessing databases from ESQL". That was the first thing that sprung to my mind and seemed to be fruitful from Google (other search engines available).
Just out of interest what sortof things had you been searching for? |
|
Back to top |
|
 |
rajesht1 |
Posted: Wed Oct 13, 2010 10:52 pm Post subject: |
|
|
Novice
Joined: 23 Jun 2010 Posts: 21
|
Hi Thanks for all your help,
I tried using the above sentence in the Google but I am not getting the extract information.If possible can u write the syntax here...... |
|
Back to top |
|
 |
rajesht1 |
Posted: Wed Oct 13, 2010 11:10 pm Post subject: |
|
|
Novice
Joined: 23 Jun 2010 Posts: 21
|
At last I got it  |
|
Back to top |
|
 |
ajit1981 |
Posted: Wed Oct 13, 2010 11:12 pm Post subject: |
|
|
Apprentice
Joined: 09 Apr 2010 Posts: 41 Location: Bangalore, Inida
|
|
Back to top |
|
 |
|