MQSeries.net :: View topic - Appending input data to output messages in ESQL

djg2004 · Posted: Mon Aug 02, 2004 2:50 am Post subject:

Hullo,

Please forgive the newbie nature of this question, I'm quite inexperienced with ESQL....

I've been give a UPES activity where I must append some of my input data container information as part of a message string which is being sent onwards to a business service.

To put this in context, the message string is a warning comment where I must advise the user that an account will be overdrawn by a certain date.

I've set up the text part as follows:
SET OutputRoot.XML."Interface".BusinessServiceInterface.CreateWorkflowObjects.WorkObjectData.CommentList.CommentText=
Account may go overdrawn by the ';

-which was straight forward enough. I'd now like to append the date component to this, which is part of the input information and is held here :
"InputBody"."WfMessage"."ActivityImplInvoke"."ProgramInputData"."CheckAccountData"."DateToStopCheck".

I realise that I could assemble the message in its entirity back in the initial java program which would then send it to WMQW/WMQI. However I'm trying to avoid overloading my data container with "user alert" messages as per the above example, which is only required when the account is likely to be overdrawn.

Is there a way to do this in ESQL ?

Thanks in advance