dbUpgrade0_9990-to-0_9991_oracle.sql 882 B

123456789101112131415161718192021222324252627
  1. -- Licensed Materials - Property of IBM
  2. --
  3. -- BI and PM: CM
  4. --
  5. -- (C) Copyright IBM Corp. 2008, 2009
  6. --
  7. -- US Government Users Restricted Rights - Use, duplication or disclosure
  8. -- restricted by GSA ADP Schedule Contract with IBM Corp.
  9. -- Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
  10. -- Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).
  11. alter table CMOBJPROPS26 add DELIVOPTIONS clob null
  12. insert into CMOBJPROPS26(CMID) SELECT CMID FROM CMOBJECTS WHERE (CLASSID = 17 OR CLASSID = 39 OR CLASSID = 55 OR CLASSID = 57) AND (CMID NOT IN (SELECT CMID FROM CMOBJPROPS26))
  13. CREATE TABLE CMOBJPROPS28 (
  14. CMID number(10) not null,
  15. EVENTKEY clob NULL,
  16. EVENTTYPES clob NULL,
  17. constraint PK_CMOBJPROPS28 primary key (CMID)
  18. )
  19. !RunCMScript CMUpgradeScript_transient_1.xml
  20. !RunCMScript CMUpgradeScript_transient_2.xml