ING_SET
This name applies to SQL, QUEL single-line terminal monitors as well as Ingres tools such as ABF, VIFRED, embedded SQL, QBF, IQUEL, ISQL, and so forth. ING_SET points to SET statements that are executed whenever this Ingres environment variable/logical takes effect.
ING_SET affects users who connect to an application, an Ingres tool, or a terminal monitor. If set globally, it affects all users. 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.
ING_SET is set to a string surrounded by quotes. The string must be 64 characters or less, or it is invalid. The string can contain either:
• One or more set statements totaling no more than 64 characters
• The word include followed by the full path name to a file containing any number of set statements
Example: Set ING_SET
To define this Ingres environment variable, use the following command syntax at the operating system prompt:
Windows:
SET ING_SET = set-statement{; set statement}
Examples:
SET ING_SET=SET LOCKMODE SESSION WHERE READLOCK=NOLOCK
SET ING_SET=include C:\users\default\mystartfile
UNIX:
C Shell:
setenv ING_SET 'set-statement {; set-statement}'
or
setenv ING_SET 'include path_to_file'
Examples:
setenv ING_SET 'SET LOCKMODE SESSION WHERE READLOCK=NOLOCK'
setenv ING_SET 'include /usr/george/mystartfile'
Bourne Shell:
ING_SET='set-statement {; set-statement}'
or:
ING_SET='include path_to_file' export ING_SET
Examples:
ING_SET='SET LOCKMODE SESSION WHERE READLOCK=NOLOCK' export ING_SET
ING_SET='include /usr/george/mystartfile' export ING_SET
VMS:
define ING_SET "set-statement {;set-statement}"
or:
define ING_SET "include path_to_file"
Examples:
DEFINE /PROCESS ING_SET "SET LOCKMODE SESSION WHERE READLOCK=NOLOCK"
DEFINE /PROCESS ING_SET ‑
"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
Last modified date: 01/30/2023