zOs/SQL/CATCOLTY

select coltype, substr(typeName,1,12) "typeName", nulls, dataTypeId,
          min(relCreated) "ri", max(relCreated) "ra", count(*)
 --   , c.*
    from sysibm.syscolumns c
    group by coltype, typeName, nulls, dataTypeId
    order by 1, datatypeId, colType, nulls, typeName
    fetch first 1000 rows only