zOs/SQL/VARS

select u.* from
    (select 'DGDB9998' db from sysibm.SysDummy1) v
    join (
        select 't ' !! strip(creator) !! '.' || strip(name) na,
               dbName db
            from sysibm.systables
            where dbName = u.db
        union select 'i ' !! strip(creator) !! '.' || strip(name) na,
               dbName db
            from sysibm.sysIndexes
         ) u
    on v.db = u.db