MQSeries.net :: View topic - accessing DB2 table with full database qualifier

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 » accessing DB2 table with full database qualifier

accessing DB2 table with full database qualifier

« View previous topic :: View next topic »

Author

Message

miron

Posted: Tue Jul 15, 2003 7:15 am Post subject: accessing DB2 table with full database qualifier

Apprentice

Joined: 27 Jun 2002
Posts: 39
Location: New York

Hello,

I want to access my DB2 table with full path (owner.table) instead of by broker alias (database.table).
Is it possible?

I do access stored procedure within same compute node by using owner.procname and have no problems with it.
When I try to select from another db2 table using owner.table it does not want to deploy.
I also tried to specify sybsystem.owner in DataSource of my flow Properties but this fails with sqlcode -950.

I appreciate any help.
Miron

chaman

Posted: Tue Jul 15, 2003 8:55 am Post subject:

Newbie

Joined: 14 Mar 2002
Posts: 7
Location: Montreal, Canada

Did you try with the PASSTHRU command?

EddieA

Posted: Tue Jul 15, 2003 11:11 am Post subject:

Jedi

Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles

Instead of:

Code:

SET OutputRoot.XML.Test.Result[] =
(SELECT T.Column1, T.Column2 FROM Database.USERTABLE AS T);

Use:

Quote:

SET OutputRoot.XML.Test.Result[] =
(SELECT T.Column1, T.Column2 FROM Database.Owner.USERTABLE AS T);

Obviously using the correct Owner

As you say it fails to deploy, then your syntax must be somehow wrong as the schema name isn't checked at that point. Post it so we can take a look.

Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » accessing DB2 table with full database qualifier

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