ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Accessing database in COMPUTE node.

Post new topic  Reply to topic
 Accessing database in COMPUTE node. « View previous topic :: View next topic » 
Author Message
harsha8127
PostPosted: Sat Oct 25, 2014 7:47 am    Post subject: Accessing database in COMPUTE node. Reply with quote

Acolyte

Joined: 25 Nov 2013
Posts: 72

Hi docs,
Actually I wanted to know whether we can use the Database in the compute node ie accessing it using esql without mentioning the database name in data source property of compute node.
Back to top
View user's profile Send private message
yadav.neeraj01
PostPosted: Sat Oct 25, 2014 9:49 am    Post subject: Reply with quote

Apprentice

Joined: 23 Feb 2011
Posts: 49

No you can not........mentioning the datasource name is mandatory to access the database through compute node..
Back to top
View user's profile Send private message Send e-mail
harsha8127
PostPosted: Sun Oct 26, 2014 7:03 am    Post subject: Reply with quote

Acolyte

Joined: 25 Nov 2013
Posts: 72

Dear Docs,
Any one has any comments.
Back to top
View user's profile Send private message
smdavies99
PostPosted: Sun Oct 26, 2014 11:47 am    Post subject: Reply with quote

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

harsha8127 wrote:
Dear Docs,
Any one has any comments.


comments? About what?

You have to mention the DSN somewhere. AFAIk, for the first DSN you use the property on the Node. Then you can use other DB's of the same type by specifying the DSN in the ESQL statement.

Please tell use what more you want to know that is not in the documentation?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.
Back to top
View user's profile Send private message
Simbu
PostPosted: Mon Oct 27, 2014 2:17 am    Post subject: Reply with quote

Master

Joined: 17 Jun 2011
Posts: 289
Location: Tamil Nadu, India

Knowledge Center Says,
Quote:
If the ESQL that is associated with this node includes a PASSTHRU statement or SELECT function and a database reference, you must specify a value for the Data Source property.
Back to top
View user's profile Send private message
Vitor
PostPosted: Mon Oct 27, 2014 5:00 am    Post subject: Re: Accessing database in COMPUTE node. Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

harsha8127 wrote:
I wanted to know whether we can use the Database in the compute node ie accessing it using esql without mentioning the database name in data source property of compute node.


I don't believe it's actually valid to mention the database name in the data source property of the compute node. That property (as the name suggests) contains the data source name, i.e. the name of the ODBC connection the node is expected to use. If that contains a database name then that purely your site naming convention; it could equally be called FRED, DATASOURCE or MINGTHEMERCILESSHATESFLASHGORDON (though I expect the last might be a bit long for some OS).

As other posters have said, it's not possible to access a database without providing a ODBC data source name to the compute node, and the software will complain if you try to do so. If you don't want the data source name to reference the database, don't reference the database in the data source name and fight it out with whoever supports your site naming standards. If you don't want the ODBC to reference a specific database name, consult the documentation for the ODBC manager on your OS to see how to achieve this. In most instances, the documentation will tell you this is impossible.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
mqjeff
PostPosted: Mon Oct 27, 2014 5:07 am    Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447

You have to mention a datasource name on the compute node if you want to use ODBC from within that compute node.

You don't have to actually use that specific datasource from within your computenode.

But it needs to be a datasource that points to the same "type" of database (Oracle, DB2, etc. etc. etc.) that your compute node code does access.

The docs are reasonably clear on how to use alternate datasources from wtihin a Compute node. Happy Reading!
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Accessing database in COMPUTE node.
Jump to:  



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
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.