MQSeries.net :: View topic - ESQL database access verses PassThru

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 » ESQL database access verses PassThru

ESQL database access verses PassThru

« View previous topic :: View next topic »

Author

Message

schroederms

Posted: Fri Dec 03, 2010 9:57 am Post subject: ESQL database access verses PassThru

Disciple

Joined: 21 Jul 2003
Posts: 169
Location: IA

Having the need to access a database with a LIKE xyz%, and the search parameter coming in on input XML has a quote in the value, example:
<NAME>O'MALLY</NAME>

Is there a way to code a like using a ESQL database call verses a Passthru, since a Passthru will not work when trying to build the string value to pass in.

Thanks in advance.
Mike

mgk

Posted: Fri Dec 03, 2010 10:19 am Post subject:

Padawan

Joined: 31 Jul 2003
Posts: 1642

Quote:

since a Passthru will not work when trying to build the string value to pass in

Why will it not work? You can escape a ' with another ' if that's the problem...

Kind Regards,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » ESQL database access verses PassThru

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