DBINFO Function

The following diagram shows the syntax of the DBINFO function.


DBINFO Function

|--DBINFO------------------------------------------------------->

>--(--+-'dbspace'--,--+-tblspace_num-+-----------------+--)-----|
      |               '-expression---'                 |      
      +-+-'sqlca.sqlerrd1'-+---------------------------+      
      | '-'sqlca.sqlerrd2'-'                           |      
      |  (1)                                           |      
      '-----+-'sessionid'----------------------------+-'      
            +-'cdrsession'---------------------------+        
            +-'dbname'-------------------------------+        
            +-'dbhostname'---------------------------+        
            +-'serial8'------------------------------+        
            +-'bigserial'----------------------------+        
            +-'get_tz'-------------------------------+        
            +-'utc_current'--------------------------+        
            +-'utc_to_datetime'--,--+-utc_value----+-+        
            |                       '-table.column-' |        
            '---'version'--,--'parameter'------------'

Notes:

Informix® extension

Element	Description	Restrictions	Syntax
column	Name of a column in the table	Must exist in table	Identifier
expression	Expression that evaluates to tblspace_num	Can contain column names, SPL variables, host variables, or subqueries, but must return a numeric value	Expression
parameter	Quoted string that specifies which part of the version string to return	For valid parameter values, see Using the 'version' Option	See the Restrictions column.
table	Table for which to display the dbspace name or containing an integer column of UTC values.	Must match the name of a table in the FROM clause of the query	Identifier
tblspace_num	Tblspace number (partition number) of a table	Must exist in the partnum column of the systables table for the database	Literal Number
utc_value	A UTC value to be converted to the DATETIME equivalent	Must be a numeric expression that evaluates to the number of seconds since 1970-01-01 00:00:00+00:00	Expression, Literal Number