Posted: Mon Jul 14, 2003 12:21 am Post subject: Destination list missing.
Apprentice
Joined: 14 Jan 2003 Posts: 34
My destination list is missing after my message passes through the following Compute note ESQL With the compute node set to 'LocalEnvironment And Message'. It appears on a trace immediately before the compute node:
Code:
DECLARE C INTEGER;
SET C = CARDINALITY(InputRoot.*[]);
DECLARE I INTEGER;
SET I = 1;
WHILE I < C DO
SET OutputRoot.*[I] = InputRoot.*[I];
SET I=I+1;
END WHILE;
-- Enter SQL below this line. SQL above this line might be regenerated, causing any modifications to be lost.
SET Environment.OutputQueue = InputLocalEnvironment.Destination.MQ.DestinationData.queueName;
SET "OutputRoot"."BLOB"."BLOB" = CAST('MQH' AS BLOB CCSID InputRoot.Properties.CodedCharSetId ENCODING InputRoot.Properties.Encoding)
|| CAST("Environment"."MQH"."SourceSystem" AS BLOB CCSID InputRoot.Properties.CodedCharSetId ENCODING InputRoot.Properties.Encoding)
|| CAST("Environment"."MQH"."SourceSystemMethod" AS BLOB CCSID InputRoot.Properties.CodedCharSetId ENCODING InputRoot.Properties.Encoding)
|| CAST("Environment"."MQH"."UniqueSequenceNo." AS BLOB CCSID InputRoot.Properties.CodedCharSetId ENCODING InputRoot.Properties.Encoding)
|| CAST("Environment"."MQH"."ResubmissionCounter" AS BLOB CCSID InputRoot.Properties.CodedCharSetId ENCODING InputRoot.Properties.Encoding)
|| CAST("Environment"."MQH"."IOIndicator" AS BLOB CCSID InputRoot.Properties.CodedCharSetId ENCODING InputRoot.Properties.Encoding)
|| CAST("Environment"."MQH"."OriginalMessageRef" AS BLOB CCSID InputRoot.Properties.CodedCharSetId ENCODING InputRoot.Properties.Encoding)
|| CAST("Environment"."MQH"."ErrorIndicator" AS BLOB CCSID InputRoot.Properties.CodedCharSetId ENCODING InputRoot.Properties.Encoding)
|| CAST("Environment"."MQH"."RoutingIndicator" AS BLOB CCSID InputRoot.Properties.CodedCharSetId ENCODING InputRoot.Properties.Encoding)
|| CAST("Environment"."MQH"."Filler" AS BLOB CCSID InputRoot.Properties.CodedCharSetId ENCODING InputRoot.Properties.Encoding)
|| CAST(InputRoot."BLOB"."BLOB" AS BLOB CCSID InputRoot.Properties.CodedCharSetId ENCODING InputRoot.Properties.Encoding);
It does not look to me like you are either explicitly or implicitly copying the Destination list from the InputLocalEnvironment to the OutputLocalEnvironment.
Joined: 28 Jun 2001 Posts: 2453 Location: Los Angeles
No. Selecting 'Copy entire message' only copies the Root tree. If you want to propogate the LocalEnvironment (and Exception) tree(s), then you have to do it yourself.
Cheers, _________________ Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0
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