Reports database property information.
Syntaxsa_db_info( [ dbidparm ] )
Argumentsdbidparm Use this optional INTEGER parameter to specify the database ID number.
Result set| 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. |
RemarksIf 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.
PermissionsNone
Side effectsNone
See also ExampleThe 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 |
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |