MQSeries.net :: View topic - ESQL code for using XML tag to determine label name

vickie_ews

Thanks for all the replies. May I share how we solved this issue?

A fieldname is identified based on the XML upper level tag. A variable (LABELVAR) is assigned to the fieldname and declared 'found.' The output destination for the labelname is set to the variable (LABELVAR).

--Msg Flow

MQInput--->Compute(AssignType&Label*) ---->Route-to-Label

Label(UNKNOWN)-->Trace--->MQOutput
Label(FACILITIES)--->Compute(Transform)--->MQOutput
Label(FINANCE)--->Compute(Transform)--->MQOutput

--ESQL
***********

SET OutputRoot = InputRoot;

-- Enter SQL below this line. SQL above this line might be regenerated, causing any modifications to be lost.

--Assign a variable to capture request type and when variable is found

DECLARE LABELVAR CHARACTER;
DECLARE BFOUND BOOLEAN;

-- Set initial variable condition
SET LABELVAR = 'UNKNOWN';
SET BFOUND = FALSE;

-- Determine type of request, assign a corresponding label name, and match found condition
IF FIELDNAME (OutputRoot."XML"."org.hn.pa.ari.Facilities") IS NOT NULL THEN
SET LABELVAR = 'FACILITIES';
SET BFOUND = TRUE;
END IF;

IF NOT BFOUND THEN
IF FIELDNAME (OutputRoot."XML"."org.hn.pa.ari.Finance") IS NOT NULL THEN
SET LABELVAR = 'FINANCE';
SET BFOUND = TRUE;
END IF;
END IF;

-- Set request variable found to the label node name

SET OutputLocalEnvironment.Destination.RouterList.DestinationData[1].labelname = LABELVAR;

gratefully,

http://www.mqseries.net/phpBB2/viewtopic.php?t=5691&start=0