MQSeries.net :: View topic

Rockon · Posted: Thu Jul 13, 2006 3:03 pm Post subject:

Hi All,

I am trying to map a source and target variables using Mapping node.
All except one of the field are one to one mappings.
For the one that requires a condition is setting the action.
If the source field comes as "Add" then the target value is "Create"
else use the incoming source value for the target.

FYI,
Sample ESQL would be:

SET V_ActionID = TRIM(InputRoot.XML."action");
SET "OutputRoot"."XML"."verb" =
CASE V_ActionID
WHEN 'Add' THEN 'Create'
ELSE V_ActionID
END;

How do I implement this logic within a Mapping Node.
Within the "Compose Mapping Expression" window, there is a block with "Apply Condition".But I am not able to generate the esql script that needs to be put in that box for this condition to be satisfied.
Any help with this regard will be appreciated.

Env: MB 5.0

Thankyou,
Cheers,