MQSeries.net :: View topic - Select query execution

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 » Select query execution

Select query execution

« View previous topic :: View next topic »

Author

Message

Oops

Posted: Sat Feb 07, 2004 3:13 am Post subject: Select query execution

Newbie

Joined: 20 Jan 2004
Posts: 9

Hi,
Can I execute a SELECT query from a compute node.
If Yes where do I specify the DSN.
Else how can I retrive the output from the databse node to a queue?

Iam using IBM WebSphere MQ Integrator Version 2.1.

Thanks

mgk

Posted: Sat Feb 07, 2004 5:06 am Post subject:

Padawan

Joined: 31 Jul 2003
Posts: 1642

Yes you can SELECT from both a Database and a Message Tree.

To SELECT from a DB, you have to specify the Datasource in the Datasource Attribute on the compute node. You also have to use the Datasource correlation name in the FROM list in the select.

See the ESQL Reference Guide, Chapter 8 "Querying External Databases"

Cheers,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions.

Oops

Posted: Sat Feb 07, 2004 10:38 pm Post subject:

Newbie

Joined: 20 Jan 2004
Posts: 9

Thanks it worked !!!

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Select query execution

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