zOs/TX/WK933FIN

select substr(t.owner, 1, 10) "owner",  substr(t.creator, 1, 8) "creat",
       substr(t.name, 1, 10), substr(pathschemas, 1, 30),
       seqno, text
    from sysibm.sysTables t, sysibm.sysViews v
    where t.creator = v.creator and t.name = v.name
        and t.name like 'VMF%' and t.type = 'V'
        and t.creator = 'OA1A'
    order by 1, 2, 3,4, 5