MQSeries.net :: View topic - HOw to check for a element accurance using ESQL.

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 » HOw to check for a element accurance using ESQL.

HOw to check for a element accurance using ESQL.

« View previous topic :: View next topic »

Author

Message

Ajju.

Posted: Thu Nov 21, 2002 9:55 am Post subject: HOw to check for a element accurance using ESQL.

Voyager

Joined: 26 Jul 2002
Posts: 77

Hi all,

I have a question that how we check that the element is present in the root tag using ESQL.

that is
<Root>
<ELEMENT1>bla bla</ELEMENT1>
<ELEMENT2>bla bla</ELEMENT2>
<ELEMENT2>bla bla</ELEMENT2>
</Root>

I wanted to test the FEILDNAME EMENET1 is present or not in
InputRoot.XML.Root.*

Thanks in Adv,
Ajju.

kirani

Posted: Thu Nov 21, 2002 3:21 pm Post subject:

Jedi Knight

Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA

I think you will have to loop thru the comple tree (onle level only) and then compare each Element name with your String (ELEMENT1). Or use a SELECT statement on input Tree, have a look at Chapter 8 in ESQL Reference manual.
_________________
Kiran

IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » HOw to check for a element accurance using ESQL.

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