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 Ingres environment variable/logical 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.

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

VMS: Global setting is with define/system, define/group, or locally with define/process in the user’s login.com file.

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

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

C Shell:

For example:

Bourne Shell:

For example:

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”.