zOs/SQL/CATCOLTS

select *
    from sysibm.syscolumns
    where colType = 'TIMESTMP' and scale <> 6
    order by tbCreator, tbName, name
    with ur