The DBINFO function

You can call the DBINFO function in a SELECT statement to find any of the following information:

• The name of a dbspace corresponding to a tblspace number or expression
• The last SERIAL, SERIAL8 or BIGSERIAL value inserted into a table
• The number of rows processed by the SELECT, INSERT, DELETE, UPDATE, MERGE, EXECUTE FUNCTION, EXECUTE PROCEDURE, or EXECUTE ROUTINE statement
• The session ID of the current session
• The name of the current database to which the session is connected
• Whether an INSERT, UPDATE, or DELETE statement is being performed as part of a replicated transaction.
• The name of the host computer on which the database server runs
• The type of operating system and the word length of the host computer
• The local time zone and the current date and time in Coordinated Universal Time (UTC) format
• The DATETIME value corresponding to a specified integer column or to a specified UTC time value (as an integer number of seconds since 1970-01-01 00:00:00+00:00)
• The exact version of the database server to which a client application is connected, or a specified component of the full version string.

The following query shows how you might use the DBINFO function to find out the name of the host computer on which the database server runs.

SELECT FIRST 1 DBINFO('dbhostname') FROM systables;

(constant)

lyceum

Without the FIRST 1 clause to restrict the values in the tabid, the host name of the computer on which the database server runs would be repeated for each row of the systables table. The following query shows how you might use the DBINFO function to find out the complete version number and the type of the current database server.

SELECT FIRST 1 DBINFO('version','full') FROM systables;