sa_db_info system procedure

sa_db_info( [ dbidparm ] )

dbidparm Use this optional INTEGER parameter to specify the database ID number.

Column name	Data type	Description
Number	INTEGER	The connection ID number.
Alias	VARCHAR(255)	The database name.
File	VARCHAR(255)	The file name of the database root file, including path.
ConnCount	INTEGER	The number of connections to the database.
PageSize	INTEGER	The page size of the database, in bytes.
LogName	VARCHAR(255)	The file name of the transaction log, including path.

If you specify a database ID, sa_db_info returns a single row containing the Number, Alias, File, ConnCount, PageSize, and LogName for the specified database.

If dbidparm is not supplied, properties for all databases are returned.

None

The following statement returns a row for each database that is running on the server:

CALL sa_db_info( );

Property	Value
Number	0
Alias	demo
File	C:\Documents and Settings\All Users\Documents\SQL Anywhere 12\Samples\demo.db
ConnCount	1
PageSize	4096
LogName	C:\Documents and Settings\All Users\Documents\SQL Anywhere 12\Samples\demo.log

sa_db_info system procedure

Syntax

Arguments

Result set

Remarks

Permissions

Side effects

See also

Example