Can the DV Netezza translator support the LIKE_REGEX predicate?
Issue
- Netezza doesn't support regular expression by default, but with the installation of SQL Extensions toolkit this functionality is added. After installation Netezza provide the regular expression functions:
regexp_extract()
regexp_extract_all()
regexp_extract_all_sp()
regexp_extract_sp()
regexp_instr()
regexp_like()
regexp_match_count()
regexp_replace()
regexp_replace_sp() - Can DV provide a configurable option in the Netezza translator by which we can enable the LIKE_REGEX predicate for Netezza?
Environment
- Red Hat JBoss Data Virtualization (DV) 6.0
- DV Netezza Translator 6.0
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.