MQSeries.net :: View topic - MQSI ESQL QUESTION

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 » MQSI ESQL QUESTION

MQSI ESQL QUESTION

« View previous topic :: View next topic »

Author

Message

k.srinivas

Posted: Thu Jun 10, 2004 6:20 am Post subject: MQSI ESQL QUESTION

Apprentice

Joined: 16 May 2002
Posts: 29
Location: chennai

HI GUYS
I HAVE AN INPUT XML MESSAGE LIKE
<A>
<B>NAME</b>
<C>ADDRESS</C>
</A>

I NEED TO CREATE AN OUTPUT MESSAGE MESSAGE BASED ON THE INPUT XML MESSAGE
FIRST I NEED TO CHECK THE INCOMMIMNG FIELDS B AND C
IF THEY ARE NOT PRESENT I NEED TO RAISE EXCEPTIONS
CAN U PLZ GIVE ME THE ESQL TO CHECK WHETHER THE FIELDS ARE PRESENT
WITH REGARDS
SRINIVAS

Posted: Thu Jun 10, 2004 7:03 am Post subject:

Padawan

Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.

Quote:

CAN U PLZ GIVE ME THE ESQL TO CHECK WHETHER THE FIELDS ARE PRESENT

I have a better idea. Why don't you take a crack at developing the code and test it. If you have problems, post the code and we'll review it for you.

What do you think ?

bindu

Posted: Thu Jun 10, 2004 9:19 am Post subject: MQSI ESQL QUESTION

Voyager

Joined: 07 May 2004
Posts: 97

IF ((TRIM("Root"."XML"."A"."B") IS NULL ) OR (TRIM("Root"."XML"."A"."B") = '' ) OR
(TRIM("Root"."XML"."A"."C") IS NULL ) OR (TRIM("Root"."XML"."A"."C") = '' ))
RETURN FALSE;
ELSE
RETURN TRUE;
END IF;

Use this code in Filter Node....connect true for mapping compute node and false to the exception generation compute node....That should be work for you.

Thanx,
Bindu

Lisa

Posted: Thu Jun 10, 2004 9:37 am Post subject: Learning ESQL

Master

Joined: 07 Jun 2002
Posts: 287
Location: NJ

k.srinivas,
Please search this forum for Redbooks, which contain the answer to most of your basic questions. The Redbooks will allow you to work with sample message flows/sets and develop your WMQI skills.

Lisa

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » MQSI ESQL QUESTION

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