Example: Set ING_SYSTEM_SET
To define this Ingres environment variable/logical use the following command entered at the operating system prompt:
Windows:
SET ING_SYSTEM_SET = set-statement{;set-statement}
For example:
SET ING_SYSTEM_SET = set autocommit on
UNIX:
C Shell:
setenv ING_SYSTEM_SET 'set-statement{; set-statement}'
For example:
setenv ING_SYSTEM_SET ’set autocommit on’
setenv ING_SYSTEM_SET ’include \
/usr/ingres/ourstartfile’
Bourne Shell:
ING_SYSTEM_SET='set-statement {; set-statement}'
or:
ING_SYSTEM_SET='include path_to_file'
export ING_SYSTEM_SET
For example:
ING_SYSTEM_SET=’set autocommit on’
export ING_SYSTEM_SET
ING_SYSTEM_SET=’include \ /usr/ingres/ourstartfile’
export ING_SYSTEM_SET
VMS:
define ING_SYSTEM_SET "set-statement {; set-statement}"
or:
define ING_SYSTEM_SET "include path_to_file "
For example:
DEFINE /SYSTEM ING_SYSTEM_SET ‑
"SET LOCKMODE SESSION WHERE READLOCK=NOLOCK"
DEFINE /SYSTEM ING_SYSTEM_SET ‑
"INCLUDE DUA1:[INGRES]OURSTART.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;