Posted: Mon Sep 01, 2008 12:19 am Post subject: Changing Correlation ID, BLOB to CHARACTER
Apprentice
Joined: 14 Jun 2008 Posts: 36
Hi,
I am using MQPlugin Node with Message Broker 6.0 on Solaris. When a message fails in my flows, I am storing the message in a failure queue, also generating an email to send to support team with correlation ID of the failure message. The CorrelationId is being populated by using the following ESQL:
SET OutputRoot.MQMD.CorrelId = InputRoot.MQMD.MsgId;
While creating the email I am casting the Correlation ID to CHARACTER, so in the email I am getting something like "AMQ LMD6UMQI H¨3Ü"8" where as I can see the correlation ID "414D51204C4D4436554D51492020202048A833DC220B3810" when I browsed the message using RFHUtil. I understand that the conversion between BLOB to CHARACTER is making the correlation ID looks different in the email. I want the email to contain the correlation ID as I can through RFHUtil. Is there any possible way to do that???
Try esql function UUIDASCHAR _________________ If you do not know the answer or you get the urge to answer with "RTFM" or "Search better in this forum", please refrain from doing so, just move on to the next question. Much appreciated.
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