Was this helpful?
II_SQL_INIT
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.
Example: Set II_SQL_INIT
To define this Ingres environment variable, use the following command syntax at the operating system prompt:
Windows:
SET II_SQL_INIT=path_to_file
UNIX:
C Shell:
setenv II_SQL_INIT path_to_file
For example:
setenv II_SQL_INIT /usr/george/mystartfile
Bourne Shell:
II_SQL_INIT=path_to_file export II_SQL_INIT
For example:
II_SQL_INIT=/usr/george/mystartfile export II_SQL_INIT
VMS:
define II_SQL_INIT path_to_file
For example:
DEFINE /PROCESS II_SQL_INIT -DUA1:[USER.GEORGE]MYSTART.FILE
The file contains lines in the following format:
set lockmode session where readlock = nolock \g
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”.
Last modified date: 01/30/2023