Filter Stage usage for LIKE %ABC%

[Titto]

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

[DSguru2B]

It supports 'Like' boolean operator. Did you try using it?
For your example, it will be Col like '%ABC%'

[ray.wurlod]

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*'

[DSguru2B]

It works with sql wild cards as well right? Where is this information documented? I checked the Parallel developers guide, its not there. Unless its in a chapter other than Filter Stage.

[ray.wurlod]

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.

[DSguru2B]

Thats strange. I built a job and after testing with '%' , I confirmed that it can be used. I dont have access to the manual so cannot test with other operators, but know for sure '%' works.

[kumar_s]

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]...

[kumar_s]

DSguru2B is right. '%' is working, contradictorily '*' is not working.

[DSguru2B]

DSguru2B is right. '%' is working, contradictorily '*' is not working.

Thanks for the confirmations Kumar. And I thought my system had a bug