sa_conn_options system procedure

sa_conn_options( [ connidparm ] )

connidparm Use this optional INTEGER parameter to specify the connection ID number. The default is NULL.

Column name	Data type	Description
Number	INTEGER	Renvoie l'identificateur (numéro) de la connexion en cours.
PropNum	INTEGER	Returns the connection property number.
OptionName	VARCHAR(255)	Returns the option name.
OptionDescription	VARCHAR(255)	Returns the option description.
Value	LONG VARCHAR	Returns the option value.

Returns the connection ID as Number, and the PropNum, OptionName, OptionDescription, and Value for each available connection property that corresponds to a database option.

If connidparm is less than zero, then option values for the current connection are returned. If connidparm is not supplied or is NULL, then option values are returned for all connections to the current database.

No privileges are required to execute this system procedure for the current connection ID. To execute this system procedure for other connections, you must have either the SERVER OPERATOR, MONITOR, or DROP CONNECTION system privilege.

None

The following example uses the sa_conn_options system procedure to display property information for connection properties that correspond to database options.

CALL sa_conn_options( );

Number	PropNum	OptionName	OptionDescription	Value
1,952	461	blocking	Controls response to locking conflicts	On
1,952	462	blocking_timeout	Controls the time a transaction waits to obtain a lock	0
...	...	...	...	...

sa_conn_options system procedure

Syntax

Arguments

Result set

Remarks

Privileges

Side effects

See also

Example