MQSeries.net :: View topic - Cardinality with Index

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Cardinality with Index

Cardinality with Index

« View previous topic :: View next topic »

Author

Message

manoj5007

Posted: Thu Jul 03, 2014 12:46 am Post subject: Cardinality with Index

Acolyte

Joined: 15 May 2013
Posts: 64

Hi,

I have requirement to count the occurence of Date field in the message and so I have the below statement in my ESQL code.
DECLARE count INTEGER CARDINALITY(InRef.NS1:XYZ.NS1:Date[]);

Though there is no warnings/errors during compile time but at the time of deployment I am encountering the below error:

" BIP2493E:
Illegal type for parameter '1' of the function 'CARDINALITY'. A list is required.

The expression supplying the parameter must evaluate to a value of a suitable type. The given expression cannot possibly do so.

Correct the syntax of your ESQL expression in node..."

I am not sure what's wrong with this syntax.

Posted: Thu Jul 03, 2014 1:40 am Post subject:

Master

Joined: 31 May 2007
Posts: 254
Location: Sweden

InRef, what is it a reference to? Sounds like the reference might be at fault.

manoj5007

Posted: Fri Jul 04, 2014 2:48 am Post subject:

Acolyte

Joined: 15 May 2013
Posts: 64

The InRef references to InputRoot.XMLNSC.Data

Please correct me if my understanding is wrong,

The broker identifies the datatype as list with help of [] and so here the broker should have identified the statement under cardinality as list and the error shouldn't have been encountered but I am not sure why the error has been encountered.

DECLARE count INTEGER CARDINALITY(InRef.NS1:XYZ.NS1:Date[]);

McueMart

Posted: Fri Jul 04, 2014 5:50 am Post subject:

Chevalier

Joined: 29 Nov 2011
Posts: 490
Location: UK...somewhere

Stick a trace node before your compute node and trace {Root}.

We'll then be able to help you for sure

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Cardinality with Index

Jump to:

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

Protected by Anti-Spam ACP