Externally stored data

In a majority of cases, the data on which you create a text index is stored within native DB2 table columns, such as in CLOBS or VARCHARS.

However, text documents that are stored externally, such as in files or other databases, are also supported. For documents that are stored in files, the DB2 Data Links feature is available. For documents that are stored on other databases, use DB2 nickname tables to create a text index.

See Related information.

You can also use the column transformation function for data that are stored in nonsupported external data stores. See Column transformation function.