MQSeries.net :: View topic - problem with accessing remote database without giving schema

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 » problem with accessing remote database without giving schema

problem with accessing remote database without giving schema

« View previous topic :: View next topic »

Author

Message

jainsk

Posted: Tue Jun 15, 2004 1:58 pm Post subject: problem with accessing remote database without giving schema

Novice

Joined: 15 Jun 2004
Posts: 13

hi
iam trying to access remote database in the compute node without specifying the schema name. its taking the current user name as the schema name. is there any way i can configure the schema name at run time

fazz

Posted: Wed Jun 16, 2004 2:43 am Post subject:

Centurion

Joined: 20 Feb 2004
Posts: 144
Location: England

Hello,

You could try using the EVAL function.
i.e. EVAL('SELECT T.COL FROM Database.' || SchemaName || '.TABLE');

Note: The EVAL function has a high performance overhead.

jainsk

Posted: Wed Jun 16, 2004 6:00 pm Post subject:

Novice

Joined: 15 Jun 2004
Posts: 13

fazz wrote:

Hello,

You could try using the EVAL function.
i.e. EVAL('SELECT T.COL FROM Database.' || SchemaName || '.TABLE');

Note: The EVAL function has a high performance overhead.

is there any other way like to set parameters in db2cli.ini file

fazz

Posted: Wed Jun 16, 2004 11:53 pm Post subject:

Centurion

Joined: 20 Feb 2004
Posts: 144
Location: England

I don't know much about the db2cli.ini file, but as far as I understand the SCHEMALIST keyword is there to restrict the schemas used to query tables, not to specify what schema a table belongs to.

Have a look at:

http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.udb.doc/ad/c0007882.htm

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » problem with accessing remote database without giving schema

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