The following functions retrieve system information:

Supply as an argument only the name of the property you want to retrieve. The functions return the value for the current server, connection, or database.

For better performance, a client application monitoring database activity should use the PROPERTY_NUMBER function to identify a named property, and then use the number to repeatedly retrieve the statistic.

Property names obtained in this way are available for many different database statistics, from the number of transaction log page write operations and the number of checkpoints performed, to the number of reads of index leaf pages from the memory cache.

The following set of statements illustrates the process from Interactive SQL:

CREATE VARIABLE propnum INT;
CREATE VARIABLE propval INT;
SET propnum = PROPERTY_NUMBER( 'CacheRead' );
SET propval = DB_PROPERTY( propnum );

The following statement sets a variable named server_name to the name of the current server:

SET server_name = PROPERTY( 'name' );

The following query returns the user ID for the current connection:

SELECT CONNECTION_PROPERTY( 'UserID' );

The following query returns the file name for the root file of the current database:

SELECT DB_PROPERTY( 'file' );

• PROPERTY_NUMBER function [System]
• PROPERTY function [System]
• DB_PROPERTY function [System]
• DB_EXTENDED_PROPERTY function [System]
• CONNECTION_PROPERTY function [System]
• CONNECTION_EXTENDED_PROPERTY function [String]
• System functions
• Sybase Central Performance Monitor features for monitoring statistics