Hi,
Can we use BETWEEN in the where clause of a Filter Stage?
I got the following error :
Parse error: Expected between [field/literal] and [field/literal], got: between "CLM_CHK_DT" "("
Parse error: Expected boolean operator (and, or) got: "'01/01/0100'".
My where clause condition in filter stage:
CUST_KEY = 68 AND CLM_CHK_DT BETWEEN TO_DATE('01/01/0100','MM/DD/YYYY') AND TO_DATE('01/01/2006','MM/DD/YYYY')
Why am i getting the above error? Please suggest...
Query regarding Filter Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
TO_DATE is a purely database function - you can not use that in a WHERE clause in a Filter stage.
Page 29-3 of the Parallel Job Developer's Guide suggests that BETWEEN is supported as an operator in the Filter stage WHERE clause property.
Page 29-3 of the Parallel Job Developer's Guide suggests that BETWEEN is supported as an operator in the Filter stage WHERE clause property.
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.