-- Licensed Materials - Property of IBM
--
-- BI and PM: CM
--
-- (C) Copyright IBM Corp. 2008, 2009
--
-- US Government Users Restricted Rights - Use, duplication or disclosure
-- restricted by GSA ADP Schedule Contract with IBM Corp.

-- Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
-- Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).


SET AUTOCOMMIT OFF;

delete from CMOBJNAMES  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMDATA  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMSTOREIDS  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS1  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS10  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS11  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS13  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS14  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS15  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS16  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS17  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS18  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS2  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS20  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS23  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS24  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS25  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS26  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS27  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS28  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS3  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS30  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS31  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS32  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS33  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS34  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS35  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS36  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS37  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS38  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS39  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS4  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS40  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS41  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS42  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS43  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS44  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS45  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS46  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS47  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS48  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS49  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS5  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS50  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS51  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS52  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS53  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS54  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS55  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS56  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS57  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS58  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS59  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS6  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS60  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS61  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS62  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS63  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS64  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS65  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS66  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS67  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS68  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS69  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS7  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJPROPS9  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMPOLICIES  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMVIEWED  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMGUIDS  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from  CMREFNOORD1  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from  CMREFNOORD2  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from  CMREFORD1  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from  CMREFORD2  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMSIZEINFO  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

delete from CMOBJECTS  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )));

update CMCAPACITY set CMPATH=chr(0) where USAGE=4;

commit;
