analytics/configuration/schemas/content/informix/dbCleanRows_informix.sql

-- Licensed Materials - Property of IBM
--
-- BI and PM: CM
--
-- (C) Copyright IBM Corp. 2008, 2019
--
-- 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).

truncate table CMOBJECTS;

truncate table CMOBJNAMES;

truncate table CMDATA;

truncate table CMOBJPROPS1;

truncate table CMOBJPROPS2;

truncate table CMOBJPROPS3;

truncate table CMOBJPROPS4;

truncate table CMOBJPROPS5;

truncate table CMOBJPROPS6;

truncate table CMOBJPROPS7;

truncate table CMOBJPROPS9;

truncate table CMOBJPROPS10;

truncate table CMOBJPROPS11;

truncate table CMOBJPROPS13;

truncate table CMOBJPROPS14;

truncate table CMOBJPROPS15;

truncate table CMOBJPROPS16;

truncate table CMOBJPROPS17;

truncate table CMOBJPROPS18;

truncate table CMOBJPROPS20;

truncate table CMOBJPROPS23;

truncate table CMOBJPROPS24;

truncate table CMOBJPROPS25;

truncate table CMOBJPROPS26;

truncate table CMOBJPROPS27;

truncate table CMOBJPROPS28;

truncate table CMOBJPROPS30;

truncate table CMOBJPROPS31;

truncate table CMOBJPROPS32;

truncate table CMOBJPROPS33;

truncate table CMOBJPROPS34;

truncate table CMOBJPROPS35;

truncate table CMOBJPROPS36;

truncate table CMOBJPROPS37;

truncate table CMOBJPROPS38;

truncate table CMOBJPROPS39;

truncate table CMOBJPROPS40;

truncate table CMOBJPROPS41;

truncate table CMOBJPROPS42;

truncate table CMOBJPROPS43;

truncate table CMOBJPROPS44;

truncate table CMOBJPROPS45;

truncate table CMOBJPROPS46;

truncate table CMOBJPROPS47;

truncate table CMOBJPROPS48;

truncate table CMOBJPROPS49;

truncate table CMOBJPROPS50;

truncate table CMOBJPROPS51;

truncate table CMOBJPROPS52;

truncate table CMOBJPROPS53;

truncate table CMOBJPROPS54;

truncate table CMOBJPROPS55;

truncate table CMOBJPROPS56;

truncate table CMOBJPROPS57;

truncate table CMOBJPROPS58;

truncate table CMOBJPROPS59;

truncate table CMOBJPROPS60;

truncate table CMOBJPROPS61;

truncate table CMOBJPROPS62;

truncate table CMOBJPROPS63;

truncate table CMOBJPROPS64;

truncate table CMOBJPROPS65;

truncate table CMOBJPROPS66;

truncate table CMOBJPROPS67;

truncate table CMOBJPROPS68;

truncate table CMOBJPROPS69;

truncate table CMOBJPROPS70;

truncate table CMOBJPROPS71;

truncate table CMOBJPROPS72;

truncate table CMOBJPROPS73;

truncate table CMOBJPROPS74;

truncate table CMOBJPROPS75;

truncate table CMOBJPROPS76;

truncate table CMOBJPROPS77;

truncate table CMOBJPROPS78;

truncate table CMOBJPROPS79;

truncate table CMOBJPROPS80;

truncate table CMOBJPROPS81;

truncate table CMOBJPROPS82;

truncate table CMOBJPROPS83;

truncate table CMOBJPROPS84;

truncate table CMOBJPROPS85;

truncate table CMOBJPROPS86;

truncate table CMOBJPROPS87;

truncate table CMOBJPROPS88;

truncate table CMOBJPROPS89;

truncate table CMOBJPROPS90;

truncate table CMOBJPROPS91;

truncate table CMOBJPROPS92;

truncate table CMOBJPROPS93;

truncate table CMPOLICIES;

truncate table CMVIEWED;

truncate table CMPROPERTIES;

truncate table CMCLASSES;

truncate table CMSYSPROPS;

truncate table CMLOCALES;

truncate table CMCRYPTOKEYS;

truncate table CMCAKEYS;

truncate table CMCAPACITY;

drop trigger CMGUIDS_TR;

truncate table CMGUIDS_BASE;

truncate table CMCAPROPS;

truncate table CMDBTEST;

truncate table CMREFNOORD1;

truncate table CMREFNOORD2;

truncate table CMREFORD1;

truncate table CMREFORD2;

truncate table CMSTOREIDS;

truncate table CMDATAUPGRADE;

truncate table CMCHECKCONSISTENCY;

truncate table CMNOTIFICATIONTABLE;

truncate table CMSIZEINFO;

truncate table CMSPLIT;

truncate table CMARCHIVESTATUS;

truncate table CMARCHIVEQUEUE;

truncate table CMDELETEQUEUE;

truncate table CMQUEUELOCK;

truncate table CMTENANTID;

truncate table CMINDEXQUEUE;

truncate table CMTAGS;

commit work;