Enable the OPTOFC Feature

The OPTOFC environment variable enables the OPTOFC feature.

You can assign the following values to the OPTOFC environment variable.

1: This value enables the OPTOFC feature. When you specify this value, you enable the OPTOFC feature for every cursor in every thread of the application.
0: This value disables the OPTOFC feature for all threads of the application.

The default value of the OPTOFC environment variable is 0. If you set this environment variable from the shell, make sure that you set it before you start the ESQL/C application.

On UNIX™ operating systems, you can set OPTOFC in the application with the putenv() system call (as long as your system supports the putenv() function). For example, the following call to putenv() enables the OPTOFC feature:

putenv("OPTOFC=1");

In Windows™ environments, you can use the ifx_putenv() function.

With putenv() or ifx_putenv(), you can activate or deactivate the OPTOFC feature for each connection or within each thread. You must call the putenv() or ifx_putenv() function before you establish a connection.

Important: HCL OneDB™ utilities do not support the IFX_AUTOFREE, OPTOFC, and IFX_DEFERRED_PREPARE environment variables. Use these environment variables only with client applications.