MQSeries.net :: View topic - Help on WTX DBQuery

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 » Help on WTX DBQuery

Help on WTX DBQuery

« View previous topic :: View next topic »

Author

Message

pratuluv

Posted: Thu Jan 05, 2012 2:14 am Post subject: Help on WTX DBQuery

Acolyte

Joined: 25 May 2011
Posts: 53

Hi, I have a scenario wherein I have to use a joint select to retrieve a particular data in WTX map.

I tried giving the below query but it does not work. Also I would like to know if there is any such option to perform a select within a select

Code:

=DBQUERY ( "SELECT CUSTOMER_ID FROM T_FCV_SWIFT_MESSAGES
WHERE TF_SENDER_REF ="+DBQUERY( "SELECT TF_SENDER_REF
FROM T_FCV_TRADE_REQUEST
WHERE FX_SENDER_REF ="+Sequence_Number IFX_TRADE_RESPONSE_MESSAGE:IFX_Response+" " ,
"-DBTYPE ODBC -SOURCE <datasourcename> -USER <userid> -PASSWORD <password>" ) +"" ,
"-DBTYPE ODBC -SOURCE <datasourcename> -USER <userid> -PASSWORD <password>" )

Please help.

lancelotlinc

Posted: Thu Jan 05, 2012 6:42 am Post subject:

Jedi Knight

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

What version are you on. Very important DB fixes went in with V8.2 Ifix 1 and V8.2 IFix 2.
_________________
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 » Help on WTX DBQuery

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