DIRECTIVES

onconfig.std value

1

range of values

0 or 1

takes effect

When the database server is shut down and restarted

environment variable

IFX_DIRECTIVES

refer to

The following material:

• Environment variables in the IBM Informix Guide to SQL: Reference
• SQL directives, in the IBM Informix Guide to SQL: Syntax
• Performance impact of directives, in your IBM Informix Performance Guide

The DIRECTIVES parameter enables or disables the use of SQL directives. SQL directives allow you to specify behavior for the query optimizer in developing query plans for SELECT, UPDATE, and DELETE statements.

Set DIRECTIVES to 1, which is the default value, to enable the database server to process directives. Set DIRECTIVES to 0 to disable the database server from processing directives. Client programs also can set the IFX_DIRECTIVES environment variable to ON or OFF to enable or disable processing of directives by the database server. The setting of the IFX_DIRECTIVES environment variable overrides the setting of the DIRECTIVES configuration parameter. If you do not set the IFX_DIRECTIVES environment variable, all sessions for a client inherit the database server configuration for processing SQL directives.