zOs/SQL/CATCOLST

select *
    from sysibm.sysColDist  cs
    WHERE cs.tbOwner = 'OA1A' and cs.tbName like 'TPV407%'
;
DELETE FROM SYSIBM.SYSCOLDIST
WHERE TBOWNER   = 'OA1A'
   AND TBNAME = 'TPV407A1'
   AND NAME   = 'ABRUFID'
;
commit
;x;
set current path = oa1a;
select SUBSTR(d.name, 1, 8), substr(c1.name, 1, 8),
        substr(c2.name, 1, 8), substr(c3.name, 1, 8),
        fosFmte7(cardf) "cardf",
        hex(colValue),
        numColumns, length(colGroupColNo), hex(colGroupColNo), d.*
    from sysibm.syscolDiststats d
    left join sysibm.syscolumns c1
    on hex(substr(d.colGroupColNo, 1, 2))
        = hex(c1.colno)
        and c1.tbCreator = d.tbOwner
        and c1.tbName = d.tbName
    left join sysibm.syscolumns c2
    on hex(substr(d.colGroupColNo, 3, 2))
        = hex(c2.colno)
        and c2.tbCreator = d.tbOwner
        and c2.tbName = d.tbName
    left join sysibm.syscolumns c3
    on hex(substr(d.colGroupColNo, 5, 2))
        = hex(c3.colno)
        and c3.tbCreator = d.tbOwner
        and c3.tbName = d.tbName
    where tbOwner   = 'A540769' and d.tbName = 'TWKEW05A1'
    order by statstime desc
;  x;
x;
set current sqlid = 'S100447';
update sysibm.sysColumns set
       statstime = '0001-01-01-00.00.00.00000'
     , colCardf = -1
    where tbCreator = 'OA1P' and tbName like 'TWM005A1'
;
commit;
--delete
--    from sysibm.syscoldist
--    where tbOwner   like 'OA1P%' and tbName like 'TWM005%'
--;
select *
    from sysibm.syscolstats
    where tbOwner   like 'OA1P%' and tbName like 'TWM005%'
;
select *
    from sysibm.syscoldist
    where tbOwner   like 'OA1P%' and tbName like 'TWM005%'
;
select *
    from sysibm.syscoldiststats
    where tbOwner   like 'OA1P%' and tbName like 'TWM005%'
;
select *
    from sysibm.syscolstats
    where tbOwner like 'BUA%' and tbName like 'XBEHL001%'