What's New in Database Extensions for Informix database server, Version 12.10

This publication includes information about new features and changes in existing functionality.

The following changes and enhancements are relevant to this publication. For a complete list of what's new in this release, go to What's new in Informix®.

Table 1. What's New in IBM® Informix Database Extensions User's Guide for Version 12.10.xC8
Overview Reference
Complex text search with regular expressions

You can now search for and replace text strings with regular expressions in SQL statements. Regular expressions combine literal characters and metacharacters to define the search and replace criteria. You run the functions from the new Informix Regex extension to find matches to strings, replace strings, and split strings into substrings. The regex functions support the POSIX 1003.2 regular expression and replacement metacharacters.

Regex pattern matching
Table 2. What's New in IBM Informix Database Extensions User's Guide for Version 12.10.xC2
Overview Reference
Enhanced basic text searching

You have several new options to customize basic text searching when you create a bts index. You can increase the maximum number of tokens to index in a document with the field_max_token index parameter, instead of being limited to the previous maximum of 10 000 tokens. You can build the bts index faster in RAM than in a temporary sbspace by including the xact_ramdirectory="yes" index parameter. You can limit the amount of memory that is available for basic text search operations with the xact_memory index parameter. You can index words that contain numbers and other characters by specifying the Alnum analyzer.

xact_ramdirectory index parameter

xact_memory index parameter

field_token_max index parameter

Alnum analyzer

Table 3. What's New in IBM Informix Database Extensions User's Guide for Version 12.10.xC1
Overview Reference
SPL routines for application compatibility

The SQL packages extension provides SPL (Stored Procedure Language) routines that you can use in an application that is compatible with other database servers. For example, the packages include large object handling, alert and message management, and random number generation.

SQL Packages Extension

Copyright© 2018 HCL Technologies Limited