select ColumnName, ColumnFormat, ColumnType,
      CASE
      WHEN col.ColumnType='AT' then 'TIME'
   WHEN col.ColumnType='BF' then 'BYTE'
   WHEN col.ColumnType='BV' then 'BLOB'
   WHEN col.ColumnType='BV' then 'VARBYTE'
   WHEN col.ColumnType='CF' then 'CHAR'
   WHEN col.ColumnType='CO' then 'CLOB'
   WHEN col.ColumnType='CV' then 'VARCHAR'
   WHEN col.ColumnType='D' then 'DECIMAL'
   WHEN col.ColumnType='DA' then 'DATE'
   WHEN col.ColumnType='DH' then 'INTERVAL DAY TO HOUR'
   WHEN col.ColumnType='DM' then 'INTERVAL DAY TO MINUTE'
   WHEN col.ColumnType='DS' then 'INTERVAL DAY TO SECOND'
   WHEN col.ColumnType='DY' then 'INTERVAL DAY'
   WHEN col.ColumnType='F ' then 'FLOAT'
   WHEN col.ColumnType='GF ' then 'GRAPHIC'
   WHEN col.ColumnType='GV ' then 'VARGRAPHIC'
   WHEN col.ColumnType='HM ' then 'INTERVAL HOUR TO MINUTE'
   WHEN col.ColumnType='HR ' then 'INTERVAL HOUR'
   WHEN col.ColumnType='HS ' then 'INTERVAL HOUR TO SECOND'
   WHEN col.ColumnType='I1 ' then 'BYTEINT'
   WHEN col.ColumnType='I2 ' then 'SMALLINT'
   WHEN col.ColumnType='I' then 'INTEGER'
   WHEN col.ColumnType='MI ' then 'INTERVAL MINUTE'
   WHEN col.ColumnType='MO ' then 'INTERVAL MONTH'
   WHEN col.ColumnType='MS' then 'INTERVAL MINUTE TO SECOND'
   WHEN col.ColumnType='SC' then 'INTERVAL SECOND'
   WHEN col.ColumnType='SZ' then 'TIMESTAMP WITH TIME ZONE'
   WHEN col.ColumnType='TS' then 'TIMESTAMP'
   WHEN col.ColumnType='TZ' then 'TIME WITH TIME ZONE'
   WHEN col.ColumnType='YM' then 'INTERVAL YEARTO MONTH'
   WHEN col.ColumnType='YR' then 'INTERVAL YEAR'
   WHEN col.ColumnType='UT' then 'UDT Type'
  ELSE ColumnType END AS ColumnType2, ColumnLength, DecimalTotalDigits, DecimalFractionalDigits
      from dbc.columns col where tablename='CUSTOMER' and databasename='TPCH';