zOs/SQL/CATTABLE

SELECT            LENGTH(CREATOR),    LENGTH(NAME),
                  STRIP(CREATOR) || '.' || STRIP(NAME)
                  || ' ' || TYPE
    FROM SYSIBM.SYSTABLES
    WHERE NAME LIKE 'VSV01%'
    ORDER BY CREATOR ASC, NAME ASC
;
XELECT 'UNION SELECT COUNT(*), '
       || '''' || STRIP(CREATOR) || '.' || STRIP(NAME) || ''''
       || ' FROM ' || STRIP(CREATOR) || '.' || STRIP(NAME)
    FROM SYSIBM.SYSTABLES
    WHERE DBNAME LIKE 'DDI0%'
    ORDER BY CREATOR ASC, NAME ASC