This name applies to the SQL single-line Terminal Monitor only. II_SQL_INIT points to SET statements within a file that are executed whenever this Actian X environment variable takes effect.

II_SQL_INIT affects users who connect to the SQL terminal monitor. If set globally, it affects all users. If set interactively or locally, it affects only this user.

Windows: Global setting is with ingsetenv, or locally in the user’s environment.

Linux: Global setting is with ingsetenv, or locally in the user’s .login, .profile or .cshrc file

Setting this environment variable is equivalent to a user’s executing \i filename in the SQL terminal monitor each time they connect to a database.

To define this Actian X environment variable, use the following command syntax at the operating system prompt:

For example:

The file contains lines in the following format:

This file contains the SET statements. If you have several SET statements, separate the statements with a semicolon (;). You must end the entire file with “\g”.