sa_conn_properties_by_name system procedure

Function

Reports connection property information

Syntax

sa_conn_properties_by_name ( [ connection-id ] )

Permissions

None.

See also

“sa_conn_properties system procedure”

Description

This is a variant on the sa_conn_properties system procedure. It returns the same result columns. The information is sorted by property name and connection number.

For a listing of available connection properties, see the section “Database properties” in the chapter “Database Performance and Connection Properties” in the Adaptive Server Anywhere Database Administration Guide.

Example

sa_conn_properties_by_name

For an example of the results returned by sa_conn_properties_by_name, see “sa_conn_properties system procedure”.