Customization of Query Runtime Environment
Most aspects of the environment in which queries execute can be customized at runtime for a particular session. This can be done by executing one or more SET statements to customize the environment before query execution begins.
Here are some examples:
• Reduce lock conflicts when running read-only queries, as for reports:
SET LOCKMODE SESSION WHERE READLOCK=NOLOCK
• Display the text of the query as it is executed:
SET PRINTQRY
Ingres makes customization flexible by permitting most components of the query environment to be set by means of set statements at the startup of individual queries (sessions). This can be done by using various Ingres environment variables and logicals and startup files that permit users to control both the target and duration of set statement customization.
A full list of set statements can be found in your query language reference guide.