Environment Variables Commonly Used with SET

SET statements are executed as part of query language startup procedures at selected levels of scope. A SET statement is entered directly at a terminal for temporary settings or executed using a Ingres environment variable/logical to establish a default option setting for all users. Several levels are shown in the following table:

Where Specified	Scope of Effect
ING_SYSTEM_SET	Executed whenever Ingres is started up, affecting all users
ING_SET	Executed whenever any Ingres tool connects to a server
ING_SET_DBNAME	Affects only Ingres tools starting up on the specified database
II_EMBED_SET	Similar to ING_SET, but diagnostic output is to a file
SET statement entered directly	In effect until changed by a subsequent SET statement for the option. This occurs by another direct SET statement or using any of the Ingres environment variables above reestablishing the default.