Home
Extending HCL OneDB™Beyond standard relational database objects, HCL OneDB™ can be extended to handle specialized data types, access methods, routines, and other objects. HCL OneDB™ includes many built-in extensions that are fully integrated in the database server. HCL OneDB™ also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for HCL OneDB™.
HCL OneDB™ extensions and DataBlade® modulesThese topics describe how to use built-in database extensions and separately installed DataBlade® modules.
Database Extensions User's GuideThe HCL OneDB™ Database Extensions User's Guide explains how to use the database extensions that come with HCL OneDB™: Large Object Locator, MQ messaging, binary data types, basic text search, node data type, HCL OneDB™ web feature service for Geospatial Data, and SQL packages.
Regex pattern matchingRegular expressions combine literal characters and metacharaters to define the search and replace criteria. You run the functions from the HCL OneDB™ Regex extension to find matches to strings, replace strings, and split strings into substrings.
Regex RoutinesYou can use regex routines to search for patterns, manipulate text strings, and configure tracing.
regex_set_trace procedureThe regex_set_trace() procedure enables the output of debug messages.

regex_set_trace procedure

The regex_set_trace() procedure enables the output of debug messages.

Syntax

regex_set_trace(
     filename    lvarchar,
     level       integer)

filename: The file name for the trace entries. The file must be accessible to the database server.

level: The trace level: 10, 20, 30, or 100. Higher values return more details.

The regex_set_trace() procedure enables the output of debug messages.

The following statement enables tracing:

Execute procedure regex_set_trace(‘/tmp/rx.log’, 20);