After you create and save external directives, you must set the environmental variables that enable the directives. The database server only searches for a directive for a query if the external directives are set on both the database server and the client.
Enable the directive using a combination of the EXT_DIRECTIVES configuration parameter, which is in the ONCONFIG file, and the IFX_EXTDIRECTIVES client-side environment variable.
The EXT_DIRECTIVE values that you can use are:
| Value | Explanation |
|---|---|
| 0 | 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 (default) | On. The directive can be used even if IFX_EXTDIRECTIVES is not set. |
The sqexplain.out file , which is described in EXPLAIN Output File, tells you if external directives are in effect.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]