Database properties
1090
Database properties
Adaptive Server Anywhere provides a set of properties that are made
available to client applications. These properties describe aspects of
connection, database and database server behavior.
Each type of property can be accessed by supplying its name as an argument
to a system function.
v To access connection properties:
♦ Use the
connection_property
system function: The following statement
returns the number of pages that have been read from file by the current
connection.
select connection_property ( ’DiskRead’ )
v To access database properties:
♦ Use the
db_property
system function: For example, the following
statement returns the page size of the current database:
select db_property ( ’PageSize’ )
v To access database server properties:
♦ Use the
property
system function: The following statement returns the
number of pages that have been read from file by the current connection.
select property ( ’MainHeapPages’ )
Connection-level properties
The following table lists properties available for each connection.
v To retrieve the value of a connection property:
♦ Use the
connection_property
system function: The following statement
returns the number of pages that have been read from file by the current
connection.
select connection_property ( ’DiskRead’ )
v To retrieve the values of all connection properties:
♦ Use the
sa_conn_properties
system procedure:
Accessing
properties
Examples
To Next Page
Loading...