Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
Data types and expressionsThese topics describe the data types and expressions that HCL OneDB™supports.
Expression
Function Expressions
DBINFO Function
Using the 'dbname' Option

Using the 'dbname' Option

You can use the 'dbname' option to retrieve the name of the current database. This option returns the identifier of the database to which the client session is currently connected.

In the following example, the user enters the 'dbname' option of DBINFO in a SELECT statement to retrieve the name of the database to which DB-Access is connected:

SELECT DBINFO('dbname') 
   FROM systables
   WHERE tabid = 1;

The following table shows the result of this query.


(constant)
stores_demo