MQSeries.net :: View topic - Help needed retrieving data from Remote DB2

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Help needed retrieving data from Remote DB2

Help needed retrieving data from Remote DB2

« View previous topic :: View next topic »

Author

Message

kishoreMuthyala

Posted: Sat May 08, 2004 6:22 am Post subject: Help needed retrieving data from Remote DB2

Apprentice

Joined: 24 Mar 2004
Posts: 35
Location: singapore

Hi ,

Iam trying to retrieve data from Remote DB2,Using Computenode.
I have created an instance of that DB2 and created a DSN in my System.
But iam unable to retrieve..Can anyone help me solving out this.
Iam giving the Datasource name which i have created with that.

regards
Kishore Muthyala

fschofer

Posted: Sun May 09, 2004 1:00 pm Post subject:

Knight

Joined: 02 Jul 2001
Posts: 524
Location: Mainz, Germany

Hi, two questions:

1) Can you access your tables via a command line select ?

2) Have you defined a ODBC connection for your remote DB2 ?

Greetings
Frank

fazz

Posted: Mon May 10, 2004 2:54 am Post subject:

Centurion

Joined: 20 Feb 2004
Posts: 144
Location: England

What error(s) are you getting?
Is the table part of a schema? is so you would have to qualify the table name with the schema name.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Help needed retrieving data from Remote DB2

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