-- 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).


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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 PATH='' where USAGE=4