zOs/SQL/CATALISE

WITH N (N) AS
(            SELect 'XPS_VPTOD000'     FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'IDS_VINDE134'     FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'XPS_VISCO001'     FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'IDS_VINSP135'     FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'IDS_VINIR136'     FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'IDS_VISCO137'     FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'IDS_VINBS138'     FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'IDS_VINOP140'     FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'IDS_VUNFX139'     FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'XPS_VINFS000'     FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'IDS_VINOP141'     FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'XPS_VTRAM000_V03' FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'XPS_VRUNRETA_V03' FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'XPS_VCAFO001_V03' FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'XPS_VCAFO002_V03' FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'XPS_VCFAM001_V03' FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'XPS_VCFAM002_V05' FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'XPS_VOPPA002_V03' FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'XPS_VOPPA003_V03' FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'XPS_VCFAM006'     FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'XPS_VTRAM001'     FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'XPS_VTXAM504'     FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'XPS_VCFAM503'     FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'IDS_VTRAM142'     FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'XPS_VUNFI006_V03' FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'XPS_VUNFI007_V02' FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'XPS_VNTP0014'            FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'VTEVENTCONDITION'        FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'VTEVENTCOMPONENTPROP'    FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'VTCASHFLOW'              FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'VTINSTREVENTEXDATE'      FROM SYSIBM.SYSDUMMY1
  UNION  ALL SELect 'VTINSTREVNTEXDTLIQAMT'   FROM SYSIBM.SYSDUMMY1
)
select n.n, t.type, t.creator
    from n
      left join sysibm.systables t
        on    n.n = t.name
    order by n.n asc, t.type asc