MQSeries.net :: View topic

Rookwood · Posted: Fri Jan 20, 2006 6:47 am Post subject:

Hi,

environment: V5.0 CSD 4 on W2K.

Task I'm trying to solve is:
I've built a list of values in three Environment tree based structures

Environment.Variables.skipColumn.Col[]
Environment.Variables.skipStoreColumn.Col[]
Environment.Variables.useStoreColumn.Col[]

I'm then wanting to use a CASE statement with IN clauses to determine if a particular character value appears in the three trees and perform processing accordingly.

I naively tried.

CASE
WHEN fieldNameValue IN (select X.Col from Environment.Variables.skipColumn[] AS X) THEN
-- perform some task
CASE
WHEN fieldNameValue IN (select X.Col from
Environment.Variables.skipStoreColumn[] AS X)
-- perform some task
etc
END CASE;

Syntax check in Toolkit ESQL Editor has no complaints. However, when I attempt to deploy the flow I receive error back stating ...expected ) but found X.." at the position of the first WHEN clause.

I can find alterative routes around this problem, e.g. build up text string of values in Col[] using concatentation and then using POSITION function in my CASE statement, but feel there must be a more elegant solution.

Thanks
Graham
_________________
GS