zOs/SQL/XB11

select t.dbName, t.tsName
     , r.partNumber, r.stage, r.storageArea || r.segment
  FROM sysibm.systables t
    join  BUA.TXBI003 R
      on substr(t.name, 3, 3) = r.storageArea
        and substr(t.name, 6, 3) = r.segment
where t.creator = 'BUA'
      and t.name like 'XB%'
      and t.dbName = 'XBDJC002' and t.tsNmae = 'SDJC012H'