Was this helpful?
DBNAME_SQL_ INIT
This name applies to the SQL single-line terminal monitor only. DBNAME_SQL_INIT points to SET statements within a file that are executed whenever this Ingres environment variable/logical takes effect.
DBNAME_SQL_INIT affects users who connect to the database specified by DBNAME through the SQL Terminal Monitor. If set globally, it affects all users of DBNAME. 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 the DBNAME_SQL_INIT environment variable/logical is equivalent to a user’s executing \filename in the SQL Terminal Monitor each time they connect to DBNAME.
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”.
Last modified date: 01/30/2023