zOs/SQL/NZ240

with p as
( select case
    when NZ240003 <= x'00D1FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' then -1
    when NZ240003 <= x'00D5FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' then 53
    when NZ240003 <= x'00D9FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' then 54
    when NZ240003 <= x'00DDFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' then 55
    when NZ240003 <= x'00E1FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' then 56
    when NZ240003 <= x'00E5FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' then 57
    when NZ240003 <= x'00E9FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' then 58
    when NZ240003 <= x'00EdFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' then 59
                                                              else 60
    end part, n.*
    from oa1a.tnz240a1 n
)
select part, count(*), hex(min(NZ240003)), hex(max(NZ240003))
    from P
    where nz240003 > x'00D0'
    group by part
;
declare global temporary table session.ins
     as (select * from oa1a.tnz240a1)
     with no data
;
insert into session.ins
    select *
        from oa1a.tnz240a1
        where NZ240003 between  x'00E6' and x'00e9FF'
        fetch first 20 rows only
;
update session.ins set NZ240003 = left(NZ240003, 19) || '?'
;
insert into oa1a.tnz240a1
    select * from session.ins
;
with p as
( select case
    when NZ240003 <= x'00D1FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' then -1
    when NZ240003 <= x'00D5FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' then 53
    when NZ240003 <= x'00D9FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' then 54
    when NZ240003 <= x'00DDFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' then 55
    when NZ240003 <= x'00E1FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' then 56
    when NZ240003 <= x'00E5FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' then 57
    when NZ240003 <= x'00E9FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' then 58
    when NZ240003 <= x'00EdFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' then 59
                                                              else 60
    end part, n.*
    from oa1a.tnz240a1 n
)
select part, count(*), hex(min(NZ240003)), hex(max(NZ240003))
    from P
    where nz240003 > x'00D0'
    group by part
;
rollback
;x;