User's Guide

Part VI. SQL Anywhere Reference

Chapter 49. SQL Anywhere System Procedures and Functions

The following catalog procedures return result sets displaying database engine, database, and connection properties in tabular form.

sa_db_info( [ database-id ] ) Returns a single row containing the Number, Alias, File, ConnCount, PageSize, and LogName for the specified database.

sa_conn_info( [ connection-id ] ) Returns the Number, Name, Userid, DBNumber, LastReqTime, ProcessTime, Port, ReqType, CommLink, NodeAddr, LastIdle, CurrTaskSw, BlockedOn, and UncmtOps properties for each connection. If no connection-id is supplied, information for all current connections to databases on the server is returned.

sa_db_properties( [ database-id ] ) Returns the database id number and the Number, PropNum, PropName, PropDescription, and Value, for each property returned by the sa_db_info system procedure.

sa_eng_properties() Returns the PropNum, PropName, PropDescription, and Value for each available engine property.

  For a listing of available engine properties, see "System functions".

sa_conn_properties( [ connection-id ] ) Returns the connection id as Number, and the PropNum, PropName, PropDescription, and Value for each available connection property.

  For a listing of available connection properties, see "System functions". These system procedures are owned by the "DBO" user ID. The PUBLIC group has EXECUTE permission on these procedures.

Examples

• The following statement returns a single row describing the current database:

       call sa_db_info
  

  Sample values are as follows:

  Property	Value
  Number	0
  Alias	sademo
  File	c:\sqlany50\sademo.db
  ConnCount	1
  PageSize	1024
  LogName	c:\sqlany50\sademo.log

• The following statement returns a set of available engine properties

       call sa_eng_properties()
  

  PropNum	PropName	...
  0	IdleCheck	...
  1	IdleWrite	...
  2	IdleChkPt	...
  ...	...	...