MQSeries.net :: View topic - WTX Node in IIB is not working for SQL DBLOOKUP/DB Query.

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 » WTX Node in IIB is not working for SQL DBLOOKUP/DB Query.

WTX Node in IIB is not working for SQL DBLOOKUP/DB Query.

« View previous topic :: View next topic »

Author

Message

Venkat10

Posted: Mon Mar 17, 2014 12:24 pm Post subject: WTX Node in IIB is not working for SQL DBLOOKUP/DB Query.

Novice

Joined: 10 Mar 2014
Posts: 19

Hello Everyone,

Hope you are doing great.

I am working on a migration project where we are converting some standalone WTX maps to IIB/WTX environment and I have some sql select statements. DBLOOKUP/DBQUERY statements are working perfectly for DB2 but not for SQL.

ODBC is configured fand mqsicvp is working perfectly . Is there any fix packs or any procedure available for this.

Hope somebody is successful in this and appreciate your any kind of guidance.

Thanks a lot.

fjb_saper

Posted: Mon Mar 17, 2014 3:41 pm Post subject: Re: WTX Node in IIB is not working for SQL DBLOOKUP/DB Query

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

Venkat10 wrote:

Hello Everyone,

Hope you are doing great.

I am working on a migration project where we are converting some standalone WTX maps to IIB/WTX environment and I have some sql select statements. DBLOOKUP/DBQUERY statements are working perfectly for DB2 but not for SQL.

ODBC is configured and mqsicvp is working perfectly . Is there any fix packs or any procedure available for this.

Hope somebody is successful in this and appreciate your any kind of guidance.

Thanks a lot.

Explain to me how the WTX map uses the configured ODBC connection of the broker?
_________________
MQ & Broker admin

Venkat10

Posted: Tue Mar 18, 2014 6:41 am Post subject:

Novice

Joined: 10 Mar 2014
Posts: 19

I thought WTX is integrated with Message Broker that means for any DB connectivity it should go through a Message broker process sorry if totally got it wrong.

Please help me out in resolving this. Thanks.

Vitor

Posted: Tue Mar 18, 2014 6:49 am Post subject:

Grand High Poobah

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

Venkat10 wrote:

I thought WTX is integrated with Message Broker that means for any DB connectivity it should go through a Message broker process sorry if totally got it wrong.

You're wrong. WTX is integrated with WMB in that you can access WTX via a node rather a web service call or one of the APIs WTX provides. It remains a stand alone piece of software.

Venkat10 wrote:

Please help me out in resolving this. Thanks.

Migrate how the stand alone maps accessed DB2 into the new solution. Use that. How the WTX maps execute will not change just because you're calling the map from a WTX node in a flow rather than from command mode.

Clearly having access to WMB may change your map's design and their need to access a database. This is one of the reasons to use both WTX & WMB; get WMB to perform some of the non-transformation functions.
_________________
Honesty is the best policy.
Insanity is the best defence.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » WTX Node in IIB is not working for SQL DBLOOKUP/DB Query.

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