4. Setting Environment Variables and Logicals : Customization of Query Runtime Environment : II_SQL_INIT : Example: Set II_SQL_INIT
 
Share this page                  
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ā€.