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 'dbhostname' OptionYou can use the 'dbhostname' option to retrieve the host name of the database server to which a database client is connected.

Using the 'dbhostname' Option

You can use the 'dbhostname' option to retrieve the host name of the database server to which a database client is connected.

This option retrieves the physical computer name of the computer on which the database server is running.

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

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

The following table shows the result of this query.


(constant)
rd_lab1