Declaring a User-Defined Function in a specific database - 7.3

Talend Open Studio User Guide
Version
7.3
Language
English
Product
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for Data Quality
Talend Open Studio for ESB
Module
Talend Studio
Content
Design and Development
Last publication date
2023-10-11
Available in...

Open Studio for Data Quality

The regular expression function is not built into all different database environments. If you want to use Talend Studio to analyze columns against regular expressions in databases that do not natively support regular expressions, you can:

Either:

  1. Install the relevant regular expressions libraries on the database.
  2. Define a query template for the database.

Or:

  1. Execute the column analysis using the Java engine. In this case, the system will use the Java regular expressions to analyze the specified column(s) and not SQL regular expressions. For more information on the Java engine, see Using the Java or the SQL engine.