MQSeries.net :: View topic - Remote Database Access.

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 » Remote Database Access.

Remote Database Access.

« View previous topic :: View next topic »

Author

Message

nishantmodak

Posted: Mon May 25, 2009 5:42 am Post subject: Remote Database Access.

Novice

Joined: 25 May 2009
Posts: 19

Hello,
I am looking for a tutorial which would help me configure the Compute Node (ESQL) to access a remote database (DB not on the broker db)

Thanks

WMBDEV1

Posted: Mon May 25, 2009 5:58 am Post subject:

Sentinel

Joined: 05 Mar 2009
Posts: 888
Location: UK

nishantmodak

Posted: Mon May 25, 2009 6:04 am Post subject:

Novice

Joined: 25 May 2009
Posts: 19

I am developing the message flow on Windows 32 bit machine.

The Remote Database that i need to access in DB2 .

mqjeff

Posted: Mon May 25, 2009 7:11 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

You create a DataSource for the remote database.

You set the name of this DataSource on the properties of the Compute node.

You write *ESQL* INSERT, DELETE, SELECT, UPDATE statements.

All of this should have been covered in your broker training.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Remote Database Access.

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