ING_SYSTEM_SET
This name applies to both SQL and QUEL single-line terminal monitors as well as Actian X tools such as ABF, VIFRED, embedded SQL, QBF, IQUEL, ISQL, and so forth. ING_SYSTEM_SET points to SET statements that are executed whenever this Actian X environment variable takes effect.
ING_SYSTEM_SET affects all users who connect to a DBMS Server through an application, an Actian X tool, or terminal monitor. It is always effective globally and can be set only by a privileged user.
ING_SYSTEM_SET is set to a string surrounded by quotes. The string must be 256 characters or less. The string can contain either:
• One or more SET statements totaling no more than 256 characters
• The word include followed by the full path name to a file containing any number of SET statements
Example: Set ING_SYSTEM_SET
To define this Actian X environment variable 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
Linux:
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
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: 04/03/2024