Posted: Thu Apr 16, 2015 4:32 am Post subject: Destination list question
Acolyte
Joined: 13 Nov 2014 Posts: 74
Hi, Good evening.
Just asking for help about this one. I would like to populate my message using destination list from the different queues called in the query. But my message goes to the DLQ. Anyway I've successfully run the destination list but I've called the data manually.
Quote:
SET Environment.Variables.NameArr[] = (SELECT T.PARM_VALUE FROM Database.GIC_ROUTING_PARMS AS T WHERE T.ROUTING_LABEL= 'WMB_N2_LDCSUB00_001' AND T.ROUTING_QUALIFIER = 'pcode001');
DECLARE I, ctrQueue INT;
SET ctrQueue = CARDINALITY(Environment.Variables.NameArr[]);
SET I = 1;
WHILE (I <= ctrQueue) DO
SET OutputLocalEnvironment.Destination.MQ.DestinationData[I].queueName= Environment.Variables.NameArr[I];
SET I = I + 1;
END WHILE;
Posted: Thu Apr 16, 2015 4:58 am Post subject: Re: Destination list question
Grand High Poobah
Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA
anon_kb wrote:
But my message goes to the DLQ.
Have you confirmed that the DLQ code is 2085? If so, what's the target queue in the DLQ header?
anon_kb wrote:
Anyway I've successfully run the destination list but I've called the data manually.
By which you mean that if you specifically put string values in the destination list it works? If so, what does the user trace show when you run the code you posted? _________________ Honesty is the best policy.
Insanity is the best defence.
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