Requirements and Restrictions

You must understand the following requirements and restrictions before you run regex pattern matching searches.

Regex support: You can use either basic or extended regular expressions, with case sensitivity or case insensitivity. Neither type of expression allows searching for a null character.; Extended regular expressions support more search and replace options than basic regular expressions.
Database server requirement: The Scheduler must be running in the database server. If the Scheduler is not running when you run regex functions, a message that the function is not found is returned.
You must have a default sbspace if you want to return a CLOB value when you replace strings.

Database requirements: The database where the regex functions are run must be logged and must not be an ANSI database. If you attempt to use a regex function in an unlogged or ANSI database, the message DataBlade registration failed is printed in the database server message log.

Data type support: To use regex pattern matching, you must provide the text data as a CHAR, LVARCHAR, NCHAR, NVARCHAR, VARCHAR, or CLOB data type.
If you want to replace text in a CLOB value with the regex_replace() function, you must have a default sbspace.

Locales and languages support: Regex queries can use single-byte character locales and UTF-8 based locales.
Important: If you use UTF-8 character encoding, including the Chinese GB18030-2000 code set, you must set the GL_USEGLU environment variable before you create the database.

Query restrictions: Regex functions do not inherently use any database indexes.