DBINFO Function

The following diagram shows the syntax of the DBINFO function. 
(1)
DBINFO Function

1  DBINFO  (
2.1  'dbspace' ,
2.2.1 tblspace_num
2.2.1 expression
2.2.1 'sqlca.sqlerrd1'
2.2.1 'sqlca.sqlerrd2'1
2.2.1  'sessionid'
2.2.1  'cdrsession'
2.2.1  'dbname'
2.2.1  'dbhostname'
2.2.1  'serial8'
2.2.1  'bigserial'
2.2.1  'get_tz'
2.2.1  'utc_current'
2.2.1  'utc_to_datetime' ,
2.2.2.1 utc_value
2.2.2.1 table.column
2.2.2.1  'version' , 'parameter'
1 )
Notes:
  • 1 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 ids_sqs_1491.html#ids_sqs_1491 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