7. Using Monitoring and Tracing Tools : Trace Utilities : SET Statement : Environment Variables Commonly Used with SET
 
Share this page                  
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.