zOs/SQL/NI02097

select ni107140, ni107146, ni107142, ni107144
    from oa1t.TNI107A101A
    order by abs(ni107142) desc
    fetch first 23 rows only
;
select ni107140, ni107146, ni107142, ni107144
    from oa1t01.TNI107A101A
    order by abs(ni107144) asc
    fetch first 23 rows only
;
select ni107140, ni107146, ni107142, ni107144
    from oa1t02.TNI107A101A
    order by abs(ni107146) desc
    fetch first 23 rows only
;
x
select ni107068, ni107071, ni107069, ni107070
    from oa1t.TNI107A101A
    order by abs(ni107069) desc
    fetch first 23 rows only
;
select ni107068, ni107071, ni107069, ni107070
    from oa1t01.TNI107A101A
    order by abs(ni107070) asc
    fetch first 23 rows only
;
select ni107068, ni107071, ni107069, ni107070
    from oa1t02.TNI107A101A
    order by abs(ni107071) desc
    fetch first 23 rows only
;
x
select ni107142, count(*)
    from oa1t.TNI107A101A
    group by ni107142
    order by ni107142 desc
;
x
-- new
select ni107140, ni107146, ni107142, ni107144
    from oa1t.TNI107A101A
;
-- old
select ni107068, ni107071, ni107069, ni107070
    from oa1T.TNI107A101A
;
-- new
select ni107140, ni107146, ni107142, ni107144
    from oa1t.TNI107A101A
;