zOs/SQL/XCSTAGE

select count(*),  stage
    from OA1P.TQZ005TECSVUNLOAD
    group by  stage
;x;
select count(*),  XC406_PART_STATUS
    from OA1P.TXC406A1
    group by  XC406_PART_STATUS
;x;
select count(*),  Xr106_DOC_STATE
    from OA1P.TXr106A1
    group by  Xr106_DOC_STATE
;x;
select count(*),  XC106_DOC_STATE
    from OA1P.TXC106A1
    group by  XC106_DOC_STATE