sa_server_option System Procedure

Overrides a server option while the server is running.

Syntax

sa_server_optionoptval )

Description

See SQL Anywhere 11.0.1 > SQL Anywhere Server - SQL Reference > System Objects > System procedures > Alphabetical list of system procedures > sa_server_option system procedure.

The OptionWatchList option has a unique definition in Sybase IQ:

Parameters

Parameter

Description

OptionWatchList

Specifies a comma-separated list of database options that you want to be notified about, or have the database server return an error for, when they are set. The string length is limited to 128 bytes. By default, it is an empty string.
CALL dbo.sa_server_option( 'OptionWatchList')
You can view the current setting for this property by executing the following query:
SELECT DB_PROPERTY( 'OptionWatchList' );
Related concepts
Syntax Rules for Stored Procedures