sa_conn_properties_by_conn system procedure

Reports connection property information.

sa_conn_properties_by_conn ( [ property-name ] )

None.

This is a variant on the sa_conn_properties system procedure. 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 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.

• The following statement returns CacheHits settings:

  sa_conn_properties_by_conn CacheHits
  

  569851433,29,'CacheHits','Cache hits','0'
  

• The following statement returns the Ansinull option setting for the current connection:

  call sa_conn_properties_by_conn( 'ansinull' )
  

  569851433,202,'Ansinull','Ansinull','ON'
  

• The following statement returns the ANSI-related option settings for the current connection:

  call sa_conn_properties_by_conn( 'ansi%' )
  

  '569851433,198,'Ansi_blanks',
  'Ansi_blanks','OFF'
  569851433,225,
  'Ansi_close_cursors_on_rollback',
  'Ansi_close_cursors_on_rollback','ON'
  569851433,199,'Ansi_integer_overflow',
  'Ansi_integer_overflow','OFF'
  569851433,203,'Ansi_permissions',
  'Ansi_permissions','ON'
  569851433,202,'Ansinull','Ansinull','ON'