Contents Index sa_conn_info system procedure sa_conn_properties_by_conn system procedure

ASA SQL Reference
  System Procedures and Functions
    System and catalog stored procedures

sa_conn_properties system procedure


Function 

Reports connection property information.

Syntax 

sa_conn_properties ( [ connection-id ] )

Permissions 

None

Side effects 

None

See also 

sa_conn_properties_by_conn system procedure

sa_conn_properties_by_name system procedure

System functions

Connection-level properties

Description 

Returns the connection id as Number, and the PropNum, PropName, PropDescription, and Value for each available connection property.

If no connection-id is supplied, properties for all current connections to the server are returned.


Contents Index sa_conn_info system procedure sa_conn_properties_by_conn system procedure