4. Setting Environment Variables and Logicals : Customization of Query Runtime Environment : ING_SET_DBNAME : Example: Set ING_SET_DBNAME
 
Share this page                  
Example: Set ING_SET_DBNAME
To define this Ingres environment variable/logical use the following command entered at the operating system prompt:
Windows:
SET ING_SET_DBNAME=set-statement {;set statement}
For example:
SET ING_SET_MYDB=SET LOCKMODE SESSION WHERE READLOCK=NOLOCK
SET ING_SET_MYDB=include C:\users\default\mystartfile
UNIX:
C Shell:
setenv ING_SET_DBNAME 'set-statement {; set-statement}'
or:
setenv ING_SET_DBNAME 'include path_to_file'
For example:
setenv ING_SET_MYDB ’SET LOCKMODE SESSION WHERE READLOCK=NOLOCK’
setenv ING_SET_MYDB ’include /usr/george/mystartfile’
Bourne Shell:
ING_SET_DBNAME='set-statement {; set-statement}'
or:
ING_SET_DBNAME='include path_to_file' export ING_SET_DBNAME
For example:
ING_SET_MYDB='SET LOCKMODE SESSION WHERE READLOCK=NOLOCK'export ING_SET_MYDB
ING_SET_MYDB='include /usr/george/mystartfile'export ING_SET_MYDB
VMS:
define ING_SET_DBNAME "set-statement {; set-statement}"
or:
define ING_SET_DBNAME "include path_to_file"
For example:
DEFINE /PROCESS ING_SET_MYDB ‑ "SET LOCKMODE SESSION WHERE READLOCK=NOLOCK"
DEFINE /PROCESS ING_SET_MYDB ‑ "INCLUDE DUA1:[USER.GEORGE]MYSTART.FILE"
For the include format, the file specified by path_to_file contains the set statements. If you have several set statements, separate the statements with a semicolon (;). Place each set statement on a separate line in the file.
For example:
set autocommit on;
set lockmode session where readlock=nolock;
set result_structure cbtree