ALTER SYSTEM

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide > ALTER statements >

ALTER SYSTEM

Previous pageReturn to chapter overviewNext page

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;

 

Using ALTER SYSTEM to set system parameters (and the documentation of those parameters) is explained in the Developer's Guide topic on Configuring SQLstream.

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.