| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| mapping node questions |
« View previous topic :: View next topic » |
| Author |
Message
|
| bulletboy |
 Posted: Tue Aug 17, 2004 10:34 am Post subject: mapping node questions |
 |
|
Newbie
Joined: 17 Aug 2004
Posts: 4
Location: Great White North
|
I am trying to use a sybase database table as the source of a mapping.
Within the Mapping node I chose to Add RDB Table Mapping Input and then select the option to Import and Add Table Schemas.
I then successfully connect to the database server and database, but none of the existing tables for that database appear on the popup window that is supposed to allow me to select the tables that I am interested in.
What am I missing???
As an alternative, Online help suggests that the DBA could export the schema files for me, but I don't know what to do with them! Do I need to manually build the xmi files from the schema and then import them into the toolkit? If so, what are the formats of the connection, database, table and schema files? Are there any samples of these available?
Thanks! |
|
| Back to top |
|
 |
| EKhalil |
| Posted: Mon Nov 29, 2004 12:10 pm Post subject: |
|
|
Voyager
Joined: 29 Apr 2003
Posts: 99
Location: Boston, MA
|
I am have the same problem. It appears that the connection is successful but there are no tables tables to choose from. No DB2 errors in log files...
Just wondering if there is a solution to this ???
Any successuf database schema imports...anyone ? |
|
| Back to top |
|
|
| JT |
| Posted: Mon Nov 29, 2004 1:14 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Quote: |
| It appears that the connection is successful but there are no tables tables to choose from |
Could the id you're using to connect, not have the necessary rights (beyond connect)? We've been able to successfully import database schemas from Oracle. |
|
| Back to top |
|
|
| EKhalil |
| Posted: Tue Nov 30, 2004 6:35 am Post subject: |
|
|
Voyager
Joined: 29 Apr 2003
Posts: 99
Location: Boston, MA
|
Thanks for the tip  explored it but that doesn't seem to be the problem:(
The source user id has the required authority to access the DB2 catalogs... |
|
| Back to top |
|
|
| EKhalil |
| Posted: Thu Dec 16, 2004 11:42 am Post subject: |
|
|
Voyager
Joined: 29 Apr 2003
Posts: 99
Location: Boston, MA
|
DBAs still have an open ticket on this one. There seem to be issues with the stored procedures used by DB2. The ODBC connection to the mainframe is fine when issued from the DB2 config assistant. Unfortunately if you try to connect from the DB2 control center, errors are thrown on the mainframe side. Similar thing happens when the WBIMB tries to connect to do his schema imports... |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
