EXT_DIRECTIVES

Home | Previous Page | Next Page Configuring and Monitoring Dynamic Server > Configuration Parameters >

EXT_DIRECTIVES

onconfig.std value

0

range of values

0, 1, 2

takes effect

When the database server is shut down and restarted

environment variable

IFX_EXTDIRECTIVES

refer to

The following material:

Environment variables and information about the sysdirectives system catalog table, in the IBM Informix Guide to SQL: Reference
SQL directives, in the IBM Informix Guide to SQL: Syntax
Using external optimizer directives, in the IBM Informix Performance Guide

The EXT_DIRECTIVES configuration parameter enables or disables the use of external SQL directives. Enable external directives by using the EXT_DIRECTIVES configuration parameter in combination with the client-side IFX_EXTDIRECTIVES environment variable as follows:

Value	Explanation
0 (default)	Off. The directive cannot be enabled even if IFX_EXTDIRECTIVES is on.
1	On. The directive can be enabled for a session if IFX_EXTDIRECTIVES is on.
2	On. The directive can be used even if IFX_EXTDIRECTIVES is not set.

The setting of the IFX_EXTDIRECTIVES environment variable overrides the setting of the EXT_DIRECTIVES configuration parameter. If you do not set the IFX_EXTDIRECTIVES environment variable, all sessions for a client inherit the database server configuration for processing external directives.