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  'onedb' , 'parameter'
1 )
Notes:
  • 1 HCL OneDB™ 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 onedb string to return For valid parameter values, see Using the 'onedb' 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