Sybase Adaptive Server Anywhere - Page 350

Alphabetical list of functions
332
♦
SQL/92 Vendor extension.
♦
Sybase Compatible with Adaptive Server Enterprise.
DB_NAME function [System]
Returns the name of a database with a given ID number.
DB_NAME ( [ database-id ] )
database-id The ID of the database. The database-id must be a numeric
expression.
The statement returns the database name asademo, when executed against
the sample database as the sole database on the server.
SELECT DB_NAME( 0 )
If no database ID is supplied, the name of the current database is returned.
♦
SQL/92 Vendor extension.
♦
Sybase Compatible with Adaptive Server Enterprise.
DB_PROPERTY function [System]
Returns the value of the given property.
DB_PROPERTY ( { property_id | property_name }
... [, { database_id | database_name } ] )
property_id The database property ID.
property_name The database property name.
database_id The database ID number, as returned by DB_ID. Typically,
the database name is used.
database_name The name of the database, as returned by DB_NAME.
The following statement returns the page size of the current database, in
bytes.
SELECT DB_PROPERTY( ’PAGESIZE’ )
Returns a string. The current database is used if the second argument is
omitted.
♦
SQL/92 Vendor extension.
Standards and
compatibility
Function
Syntax
Parameters
Examples
Usage
Standards and
compatibility
Function
Syntax
Parameters
Example
Usage
Standards and
compatibility