Filter Stage usage for LIKE %ABC%
Moderators: chulett, rschirm, roy
Filter Stage usage for LIKE %ABC%
hello,
Can the filter stage used to filter the data where LIKE %ABC% - same as we provide in SQL?
if not, what could be the alternative to use the LIKE condition to use %ABC%.
Any info helpful and appreciated.
Thanks
Can the filter stage used to filter the data where LIKE %ABC% - same as we provide in SQL?
if not, what could be the alternative to use the LIKE condition to use %ABC%.
Any info helpful and appreciated.
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The Filter stage is a strange hybrid. With LIKE it expects regular expressions rather than SQL wildcards. Therefore what you need is
Code: Select all
LIKE '*ABC*'
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Manuals from IBM training classes and Orchestrate Operators manual page 7-8.
The latter lists all the recognized regular expression characters and "%" is not among them.
IBM Center of Excellence claims that the Transformer stage is now faster than the Filter stage because the latter is interpreted; take this advice with skepticism until you test it.
The latter lists all the recognized regular expression characters and "%" is not among them.
IBM Center of Excellence claims that the Transformer stage is now faster than the Filter stage because the latter is interpreted; take this advice with skepticism until you test it.
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.
But If I recall properly, once I did testing on '*' in filter, which didn't gave your the expected output. I posted the result in this forum as well in some of the post. But I dont have access to test now.
But Iam sure that, its works with patter matching. Like [a-z][a-h]...
But Iam sure that, its works with patter matching. Like [a-z][a-h]...
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'