MQSeries.net :: View topic - syntaxis error in an ESQL statement

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 » syntaxis error in an ESQL statement

syntaxis error in an ESQL statement

« View previous topic :: View next topic »

Author

Message

lacasort

Posted: Tue Apr 02, 2013 4:00 pm Post subject: syntaxis error in an ESQL statement

Newbie

Joined: 02 Apr 2013
Posts: 1

Hello, I would to execute the next sentence into esql, where ID_TAREA and ID_TANSACCION are parameters:

SELECT XML_BITACORA_IN

FROM ESEONEG.ODS_EVENTO ods

WHERE XMLEXISTS('$i//asignarTransaccionData[ID_TAREA = 1259223]'

passing XML_BITACORA_IN as "i")

AND XMLEXISTS('$i//asignarTransaccionData[ID_TRANSACCION = "GC201303141001"]'

passing XML_BITACORA_IN as "i")

AND CVE_EVENTO = '10009'

ORDER BY TS_INICIO_EVENTO DESC;

But, when I put the sentence this sends me a syntaxis error.

Vitor

Posted: Tue Apr 02, 2013 4:44 pm Post subject:

Grand High Poobah

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

That's because it's not syntaxisly correctly ESQL.

If you intend (as I suspect) to run this against a database you may need to pass it directly.

But as you've not said one word about what you're trying to do (or even bothered to mention which element, if any, was reported as incorrect) it's almost impossible to offer any advice.
_________________
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 » syntaxis error in an ESQL statement

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