ALTER SYSTEM

Syntax

ALTER SYSTEM SET <system_parameter> = [ <literal> | MAX | MIN ]

Example

ALTER SYSTEM modifies the value of a system parameter. The new value is retained until it is replaced by a subsequent ALTER SYSTEM, or the SQLstream system is shut down. For example:

ALTER SYSTEM SET auto_commit = TRUE;

The SQLstream s-Server Administrator Guide topic on Configuring SQLstream explains using ALTER SYSTEM to set system parameters, which are defined in this topic.

See also: the topic ALTER SESSION in this guide, as well as the topics Configuring SQLstream and Managing and Monitoring s-Server in the SQLstream s-Server Administrator Guide.