System Functions

System functions return system information.

Description

Databases currently running on a server are identified by a database name and a database ID number. The db_id and db_name functions provide information on these values.

A set of system functions provides information about properties of a currently running database, or of a connection, on the database server. These system functions take the database name or ID, or the connection name, as an optional argument to identify the database or connection for which the property is requested.

Performance

System functions are processed differently than other SAP Sybase IQ functions. When queries to SAP Sybase IQ tables include system functions, performance is reduced.

Adaptive Server System Function Compatibility
Not all Adaptive Server system functions are implemented in SAP Sybase IQ.
Connection Properties
Retrieve the value of a specific connection property or the values of all connection properties.
Properties Available for the Server
Retrieve the value of a specific server property or the values of all server properties.
Properties Available for Each Database
You can retrieve the value of a specific database property or the values of all database properties. Database properties apply to an entire database.

Parent topic: SQL Functions

Created December 19, 2013. Send feedback on this help topic to Technical Publications: pubs@sap.com