| Author |
Message
|
| harsha8127 |
 Posted: Sat Oct 25, 2014 7:47 am Post subject: Accessing database in COMPUTE node. |
 |
|
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 |
|
 |
| yadav.neeraj01 |
| Posted: Sat Oct 25, 2014 9:49 am Post subject: |
|
|
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 |
|
|
| harsha8127 |
| Posted: Sun Oct 26, 2014 7:03 am Post subject: |
|
|
Acolyte
Joined: 25 Nov 2013
Posts: 72
|
Dear Docs,
Any one has any comments. |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Sun Oct 26, 2014 11:47 am Post subject: |
|
|
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 |
|
|
| Simbu |
| Posted: Mon Oct 27, 2014 2:17 am Post subject: |
|
|
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 |
|
|
| Vitor |
| Posted: Mon Oct 27, 2014 5:00 am Post subject: Re: Accessing database in COMPUTE node. |
|
|
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 |
|
|
| mqjeff |
| Posted: Mon Oct 27, 2014 5:07 am Post subject: |
|
|
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 |
|
|
|
|
