The EtxFilterTraceFile() routine

The EtxFilterTraceFile() routine enables tracing for filter operations.

Syntax

EtxFilterTraceFile ( filename)
Element Purpose Data type
filename The full path name of the trace file, relative to the server computer. The informix user must be able to write to this file. LVARCHAR

Return type

None.

Usage

Use the EtxFilterTraceFile() procedure to set a trace log when you build an index on a column and specify FILTER='CONTINUE_ON_ERROR'.

After you have enabled tracing, you can disable tracing only by ending your user session.

See The FILTER parameter for more information about filtering and the FILTER index parameter.

Example

The following example sets up a trace file for filtering operations in a temporary directory:
EXECUTE PROCEDURE EtxFilterTraceFile ('/tmp/etx_errors');