MQSeries.net :: View topic - Like in select statement in esql in IIB10

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 » Like in select statement in esql in IIB10

Like in select statement in esql in IIB10

« View previous topic :: View next topic »

Author

Message

vikas.bhu

Posted: Thu Sep 22, 2016 5:41 am Post subject: Like in select statement in esql in IIB10

Disciple

Joined: 17 May 2009
Posts: 159

i am passing following query in ESQL in ORACLE DB.
PASSTHRU('
SELECT COUNT(LOG_ID) as NUM FROM ESB E
WHERE E.LOG_MSGTYPE like ?'
VALUES( msgType ).

It is returning values only when % is passed in msgtype no in any other case.Even I hard code '''123''' or any other combination .but no luck.
Pls help

timber

Posted: Thu Sep 22, 2016 7:53 am Post subject:

Grand Master

Joined: 25 Aug 2015
Posts: 1292

What have you tried? We don't want to suggest a bunch of things that you have already ruled out.

vikas.bhu

Posted: Thu Sep 22, 2016 11:09 pm Post subject:

Disciple

Joined: 17 May 2009
Posts: 159

I tried even hard coding and values in that..but always getting no row found

adubya

Posted: Thu Sep 22, 2016 11:33 pm Post subject:

Partisan

Joined: 25 Aug 2011
Posts: 377
Location: GU12, UK

What happens when you run the same statement on your database directly rather than through IIB ?
_________________
Independent Middleware Consultant
andy@knownentity.com

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Like in select statement in esql in IIB10

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