Hi All,
What I need from the below query to check,
if the rejected_count >= 3,
forward stream to rejectedThreeTimesStream
else
forward to outStream
Here, rejectedCount table is a mysql table.
Is this valid (below query) ?
from inputStream join rejectedCount[rejected_count>=3]
on inputStream.pan = countTable.pan
select inputStream.pan
insert into rejectedThreeTimesStream
What is the recommended way of checking a mysql db table condition with
incoming stream ?
Regards
--
*Chamin Nalinda*
Intern - Engineering
WSO2 Inc. http://www.wso2.com
lean.enterprise.middleware
Mobile: (+94) 77 241 66 04
Linkedin: https://www.linkedin.com/in/chaminnalinda
Web: http://www.ckreativity.com
Blog: http://techspiro.blogspot.com/
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
