| Author |
Message
|
| viswanath |
 Posted: Wed Nov 16, 2005 10:30 am Post subject: Rgarding multiple databases |
 |
|
Apprentice
Joined: 09 Jun 2005
Posts: 33
|
hai can any body suggest a procedure to
Insert the data into 2 tables in different databases(oracle,db2)...
thanks |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed Nov 16, 2005 10:35 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You can only specific one database per database-aware node (Compute, Database, DataInsert, DataUpdate,DataDelete).
Therefore, to do work with two databases, you need two nodes.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| viswanath |
| Posted: Wed Nov 16, 2005 10:46 am Post subject: In MB 6.0 there is an enhancement |
|
|
Apprentice
Joined: 09 Jun 2005
Posts: 33
|
hai
thanks for u r reply.In MB 6.0 there is an enhancement that we can access multiple databases in a single compute node....
can u give details how to do that...
thanks |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Nov 16, 2005 11:11 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I thought this restriction had gone away in v6 as well, but the Compute Node Properties still says it can only use one.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| wschutz |
| Posted: Wed Nov 16, 2005 11:27 am Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
Yes, you can specify multiple database in a compute node, viz:
| Quote: |
FROM clause FieldReferences can contain expressions of any kind (for example, Database.{DataSource}.{Schema}.Table1).
|
I haven't tried it (yet), but I would assume that if you don't specify the {DataSource}, the one on the properties pane is used.
_________________
-wayne |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Nov 16, 2005 11:47 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
|
| Back to top |
|
|
| viswanath |
| Posted: Wed Nov 16, 2005 11:49 am Post subject: link |
|
|
Apprentice
Joined: 09 Jun 2005
Posts: 33
|
can u suggest a link if u find a scenario on this task.....
thanks |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Nov 16, 2005 11:52 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
All the information you need is right here in this thread.
You just specify the different databases in your esql by their ODBC data source name.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| viswanath |
| Posted: Wed Nov 16, 2005 1:07 pm Post subject: thanks |
|
|
Apprentice
Joined: 09 Jun 2005
Posts: 33
|
|
| Back to top |
|
|
|
|
