Example: Set DBNAME_SQL_INIT
To define this Ingres environment variable, use the following command syntax at the operating system prompt:
Windows:
SET DBNAME_SQL_INIT = path_to_file
where:
DBNAME is the name of the database and must be in uppercase.
For example:
SET MYDB_SQL_INT=c:\user\mystartfile
UNIX:
C Shell:
setenv DBNAME_SQL_INIT path_to_file
For example:
setenv MYDB_SQL_INIT /usr/george/mystartfile
Bourne Shell:
DBNAME_SQL_INIT=path_to_file export DBNAME_SQL_INIT
For example:
MYDB_SQL_INIT=/usr/george/mystartfile export MYDB_SQL_INIT
where:
DBNAME is the name of the database and must be in uppercase.
VMS:
define DBNAME_SQL_INIT path_to_file
For example:
DEFINE /PROCESS MYDB_SQL_INIT DUA1:[USER.GEORGE]MYSTART.FILE
where:
DBNAME is the name of the database and must be in uppercase.
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”.