zOs/SQL/WK1

select part, count(*),
        max(char(v1, 40)), max(char(v2, 40)), max(char(v3, 40))
    from gdb9998.twk600a190
    where v1 like '-chk %'
    group by part
    order by 1
;
x
select part, count(*),
        min(i1), max(i1),
        min(i2), max(i2),
        left(max(char(left(v1, 200),200)), 10),
        left(max(char(left(v2, 200), 200)), 10),
        left(max(char(left(v3, 200), 200)), 10)
    from gdb9998.twk600a030
    group by part
    order by part
    with ur