MQSeries.net :: View topic

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 » Exception List

Exception List

« View previous topic :: View next topic »

Author

Message

madi

Posted: Mon Mar 06, 2006 8:34 am Post subject: Exception List

Chevalier

Joined: 17 Jan 2006
Posts: 475

Hi all

I am using the following code to access the Exception List

Code:

SET Path = 'InputExceptionList.*[1]';

   WHILE EVAL( 'FIELDNAME(' || Path || ') IS NOT NULL' ) DO

      IF EVAL( 'FIELDNAME(' || Path || '.Number) IS NOT NULL' ) THEN

         SET Error = EVAL( Path || '.Number' );
         IF EVAL(Path || '.Insert.Text') <> '' THEN
            SET alertText = EVAL(Path || '.Insert.Text');
         ELSE SET alertText = EVAL(Path || '.Text');
         END IF;
         SET alertSource = EVAL(Path || '.Label');
         SET Severity = EVAL(Path || '.Severity');

      END IF;

      SET Path = Path || '.*[<]';

   END WHILE;

I get the following xml when i add some eSQL code and set to the values that I extracted from the above code

Code:

<alertMessageType>BatchPMR</alertMessageType>
<alertText>'0'</alertText>
<alertSource>TRB_INO_INB_FLOW.Service_Message</alertSource>

Is there a better way of doing this?

And also, why did I get the '&apos value in alertText

plz help

jsware

Posted: Thu Mar 16, 2006 5:59 am Post subject:

Chevalier

Joined: 17 May 2001
Posts: 455

The IBM manuals say you should do the following to access the exception list. Do a search in the help for "ExceptionList" and its in the list of found topics:

Quote:

The following ESQL shows how you can access the ExceptionList and process each child that it contains:

-- Declare a reference for the ExceptionList
-- (in a Compute node use InputExceptionList)
DECLARE start REFERENCE TO ExceptionList.*[1];

-- Loop through the exception list children
WHILE start.Number IS NOT NULL DO
-- more ESQL

-- Move start to the last child of the field to which it currently points
MOVE start LASTCHILD;
END WHILE;

Creating a reference to the "current" exception and then referencing it should get rid of all your "EVAL" function calls.
_________________
Regards
John
The pain of low quaility far outlasts the joy of low price.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Exception List

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