zOs/SQL/CATV9NEU

select dbname, name,
    case when maxPartitions > 0 then 'partitionByGrowth ' else '' end
 || case when partitions > 0 and segSize > 0
        then 'universal ' else '' end
 || case when log <> 'Y' then 'notLogged ' else '' end
    from sysibm.systablespace
    where dbname = 'DGDB9998' and name like 'A5%'
;
select char(strip(creator) || '.' || strip(name), 20),
    case when append <> 'N' then 'append ' else '' end
    from sysibm.systables
    where creator = 'GDB9998' and name like 'TWK5%'
;
select char(strip(tbCreator) || '.' || strip(tbName)
                           || '.' || strip(name), 30),
      case when hidden <> 'N' then 'hidden ' else '' end
   || case when coltype in('BIGINT', 'BINARY', 'VARBIN', 'DECFLOAT'
          , 'XML') then strip(colType) || ' ' else '' end
   || case when default in ('E','F') then 'eachRowOnUpdate ' else '' end
      , c.*
    from sysibm.sysColumns  c
    where tbCreator = 'GDB9998' and tbName like 'TWK5%'
;
select char(strip(creator) || '.' || strip(name), 20) ,
      case when compress <> 'N' then 'compress ' else '' end
   || case when ix_extension_type <> '' then 'expression ' else '' end
     ,  x.*
    from sysibm.sysIndexes  x
    where creator = 'GDB9998' and name like 'IWK5%'
;
 -- TS    partition by growth
 --       universal
 --       log no
 -- table append
 --       partition by size                  xxx für ts by growth
 --       implicitly hidden
 --       bigInt
 --       binary
 --       varBinary
 --       decFloat
 --       row change timestamp
 --       xml
 -- index compress
 --       on expression
 -- trigger instead of
 -- procedures: native sql
 -- cat sysibm.sysenvironment (für native sql Proc + index on Expr)