Hi all
Someone can help me out as i want to apply filter stage condition which can check for length of a column and based on it data could be transferred to different output streams.where condition currently used is
length(col_name) = 2
but i am getting below error
filter_countryname: Parse error: Expected comparison, 'between', or 'like' operator, got: "("
Parse error: Expected boolean operator (and, or) got: "country".
Parse error: Expected comparison, 'between', or 'like' operator, got: "("
Parse error: Expected boolean operator (and, or) got: "country".
Regards,
Where Clause of Filter stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 197
- Joined: Sun Jul 15, 2007 11:45 pm
- Location: Prague
-
- Premium Member
- Posts: 197
- Joined: Sun Jul 15, 2007 11:45 pm
- Location: Prague
Re: Where Clause of Filter stage
Its giving same sort of error.Filter where is like a constraint so i am wondering there should be a way to handle length function ......
DS_FocusGroup wrote:Hi all
Someone can help me out as i want to apply filter stage condition which can check for length of a column and based on it data could be transferred to different output streams.where condition currently used is
length(col_name) = 2
but i am getting below error
filter_countryname: Parse error: Expected comparison, 'between', or 'like' operator, got: "("
Parse error: Expected boolean operator (and, or) got: "country".
Parse error: Expected comparison, 'between', or 'like' operator, got: "("
Parse error: Expected boolean operator (and, or) got: "country".
Regards,
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
SQL functions are not permitted in the WHERE clause of a Filter stage. Refer to the Parallel Job Developer's Guide for full information about what is permitted.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.