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

sa_conn_properties_by_conn system procedure

Function 

Reports connection property information.

Syntax 

sa_conn_properties_by_conn ( [property-name ] )

Permissions 

None

Side effects 

None

See also 

sa_conn_properties system procedure

Connection-level properties

Description 

This is a variant on the sa_conn_properties system procedure, and returns the same result columns. It returns results only for connection properties that match the property-name string. You can use wildcards in property-name, as the comparison uses a LIKE operator. The result set is sorted by connection number and property name.

For a list of available connection properties, see Connection-level properties.

Example 

• The following statement returns the AnsiNull option setting for all connections:

  CALL sa_conn_properties_by_conn( 'ansinull' )

• The following statement returns the ANSI-related option settings for all connections:

  CALL sa_conn_properties_by_conn( 'ansi%' )