--order 502615, itest 10 (analysis changed)

UPDATE PRODUCT P
SET P.PRODUCTGROUP_ID = (SELECT MIN (PRODUCTGROUP_ID) FROM PRODUCTGROUP )
WHERE P.PRODUCTGROUP_ID IS NULL;

commit;

DROP INDEX XIF265PRODUCT;

      
      /*
      CHANGE REPORT for Table PRODUCT
      ACTION is ALTER or modify Table PRODUCT
      IMPACT ANALYSIS REPORT for ALTER or modify Table PRODUCT
          - index XIF265PRODUCT needs to be removed in order to proceed. 
      */

ALTER TABLE PRODUCT MODIFY (PRODUCTGROUP_ID NOT NULL);

CREATE INDEX XIF265PRODUCT ON PRODUCT
(
       PRODUCTGROUP_ID                ASC
);

