MQSeries.net :: View topic - Business Integration Monitor

BenBaumann · Posted: Thu Jul 28, 2005 10:16 am Post subject:

I am trying to create a expression that is a little more complex than simply assigning a varible. I am trying to look at a variable (string type), determine if it evaluates larger than a character field, then assign a value.

I have read almost all of the help file about business measures, data metrics, expressions... I know that an expression has to evaluate to true or false, however it seems odd that you can also assign a datametric to that field which is of any type.

Here is what I have now. Where DM_STRINGVALUE is a data metric defined by an input container value. The "result 1/2" fields are strings I would like to display in the business measure depending on the outcome.

When I do a check on this statement I get the error, "Not a field name" or "Parameter type mismatch". This is confusing because I know that DM_STRINGVALUE is a proper datametric and the "C" is also properly formatted according to the help file.

IF ((DM_STRINGVALUE <= "C"), "result 1", "result 2")

I have tried just about every combination of including quotes, not including quotes, single, double quotes, a numeric result, character result.

The only thing that I got to pass the check was a formula like this:
IF(1 < 0, 1,0)
this also:
IF(1 < 0, "error","pass")

Has anyone ever tried something like this in a business measure? Is there a special string compare function I do not know about?

Thanks,
Ben