| Author |
Message
|
| Arushi |
 Posted: Fri Jan 19, 2007 5:47 am Post subject: Problem accessing DB2 table from MB Toolkit |
 |
|
Novice
Joined: 12 Jan 2007
Posts: 21
|
Hi,
I am facing problem while accessing the database table from toolkit.Am getting warning message in the Problems tab for accessing the DB2 database from WBI Toolkit.The message i get is "Unresolvable database table reference 'Customer.Name'".
I have DB2 enterprise server 8.2 version, Message broker 6.I have created table Customer under database Employee with columns Name,Age,Address,ID in DB2 manually.In the compute node, i have given the datasource name as Employee and my esql code is something like this:
SET OutputRoot.XML.Name=SELECT Name from Database.Customer where Customer.ID='567'.
I have created the ODBC entry for new created database also. But still i get this message. Can anybody help? I need the resolution urgently.
Thanks,
Arushi |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Fri Jan 19, 2007 5:56 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
It's a warning.
You can ignore it.
Or you can create a database connection in your workspace and make sure the flow project knows how to find that connection.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| MQWays |
| Posted: Sun Apr 06, 2008 5:29 am Post subject: |
|
|
Acolyte
Joined: 20 Jan 2008
Posts: 61
|
hi,
Could you please state step-by-step on how to create database connection in the workspace and how to make sure that the flow project knows how to find that connection. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sun Apr 06, 2008 3:33 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
  
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| MQWays |
| Posted: Sun Apr 06, 2008 9:28 pm Post subject: |
|
|
Acolyte
Joined: 20 Jan 2008
Posts: 61
|
Arushi mentioned that he successfully created the ODBC stanza and the database with its tables. Yet, unresolvable database table reference pops up. I have the same issue.
I am looking for more detail as to Jeff's reply on creating DB connection in the workspace and identying it to the Message Flow Project. It will be good if you could point out the manual and section as I have read through many manuals and the information center but couldn't find much. Not to claim that I have read every line of every relevant manual....... no one can I believe.
 |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Sun Apr 06, 2008 9:41 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
create database schema using data perspective, you can avoid the warnings like this. 
verify the DSN 
Regards
gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| MQWays |
| Posted: Mon Apr 07, 2008 12:38 am Post subject: |
|
|
Acolyte
Joined: 20 Jan 2008
Posts: 61
|
|
| Back to top |
|
|
| EddieA |
| Posted: Mon Apr 07, 2008 8:47 am Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
| MQWays wrote: |
| Arushi mentioned that he successfully created the ODBC stanza and the database with its tables. Yet, unresolvable database table reference pops up. I have the same issue. |
The ODBC.ini file is only used by the Broker, not the ToolKit. For the ToolKit you provide all the connection details locally.
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
|
|
