create table PRT510_2017
as
(
SELECT * FROM MROKG510
WHERE PRTCHKYN='N'
);

UPDATE MROKG510
set PRTCHKYN='Y'
WHERE PRTCHKYN='N';

COMMIT;