zOs/SQL/OCF

select tid150md, tid150tst, tid150uui, tid150cha from oa1a . tid150a1;
select tid150md, tid150tst, tid150uui, tid150cha from oa1a . tid150a1
  where tid150md = 1010
    and TID150TST >= '2004-10-10-11.06.00.000000'
    and tid150uui like '% %'
union select tid150md, tid150tst, tid150uui, tid150cha
  from oa1a.tid150a1
  where tid150md > 1010
    and tid150md  < 1013
    and tid150uui like '%'
union select tid150md, tid150tst, tid150uui, tid150cha
  from oa1a.tid150a1
  where tid150md = 1010
    and TID150TST <= '2004-10-13-21.48.00.000000'
    and tid150uui like '% %'
order by tid150tst desc;