Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   SQL Statements > SAVE EXTERNAL DIRECTIVES >

Enabling External Directives for a Session

External directives are ignored if the EXT_DIRECTIVES parameter is set to 0 in the ONCONFIG file. In addition, the client system can disable this feature for its current session by setting the IFX_EXTDIRECTIVES environment variable to 0.

The following table shows whether external directives are disabled (OFF) or enabled (ON) for various combinations of valid IFX_EXTDIRECTIVES settings on the client system and valid EXT_DIRECTIVES settings on Dynamic Server:

EXT_DIRECTIVES = 0 EXT_DIRECTIVES = 1 EXT_DIRECTIVES = 2
IFX_EXTDIRECTIVES Not Set OFF OFF ON
IFX_EXTDIRECTIVES = 1 OFF ON ON
IFX_EXTDIRECTIVES = 0 OFF OFF OFF

If EXT_DIRECTIVES is set to 1 or 2 when the database server is initialized, then the server is enabled for external directives. Individual sessions can enable or disable external directives by setting IFX_EXTDIRECTIVES, as the table shows. Any settings other than 1 or 2 are interpreted as zero, disabling this feature.

When external directives are enabled, the status of individual external directives is specified by the ACTIVE, INACTIVE, or TEST ONLY keywords. (But only queries on which directives are effective can benefit from external directives.)

Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]