MQSeries.net :: View topic - Confugrable Service and 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 » Confugrable Service and DB2

Confugrable Service and DB2

« View previous topic :: View next topic »

Author

Message

Gideon

Posted: Tue Jul 05, 2011 5:16 pm Post subject: Confugrable Service and DB2

Chevalier

Joined: 18 Aug 2009
Posts: 403

I want to access a DB2 database and retrieve a row from a table named CATALOG.

Apparently I need to have a flow with a DatabaseRetrieve Node, never did that before

According to the doc I apparently need a NEW configurable server.

I am reading the following doc:

http://publib.boulder.ibm.com/infocenter/wmbhelp/v7r0m0/index.jsp?topic=/com.ibm.etools.mft.doc/ac37390_.htm

What the doc does not tell me is how to configure the service for use by DB2

Is there any doc or info you can point me to on how to do this ?

Thanks in advance

Vitor

Posted: Wed Jul 06, 2011 4:19 am Post subject: Re: Confugrable Service and DB2

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

Gideon wrote:

Apparently I need to have a flow with a DatabaseRetrieve Node

Or use a Compute node with a SELECT statement. 6 to one, half dozen to the other.

Gideon wrote:

Is there any doc or info you can point me to on how to do this ?

I'd start with this. this and this.

edited to remove humiliating typo
_________________
Honesty is the best policy.
Insanity is the best defence.

Last edited by Vitor on Wed Jul 06, 2011 4:38 am; edited 1 time in total

lancelotlinc

Posted: Wed Jul 06, 2011 4:34 am Post subject:

Jedi Knight

Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA

This resource has an excellent tutorial on doing just what you want (viewable right from your desktop):

http://www-304.ibm.com/jct03001c/services/learning/ites.wss/au/en?pageType=course_description&includeNotScheduled=y&courseCode=VM663AU
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Confugrable Service and 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