dbUpgrade7_0017-to-7_0018_oracle.sql 602 B

12345678910111213141516171819202122
  1. -- Licensed Materials - Property of IBM
  2. --
  3. -- BI and PM: CM
  4. --
  5. -- (C) Copyright IBM Corp. 2013
  6. --
  7. -- US Government Users Restricted Rights - Use, duplication or disclosure
  8. -- restricted by GSA ADP Schedule Contract with IBM Corp.
  9. CREATE TABLE CMOBJPROPS83 (
  10. CMID number(10) not NULL,
  11. MOBILECONFIG blob null,
  12. CONSTRAINT PK_CMOBJPROPS83 PRIMARY KEY (CMID)
  13. );
  14. insert into CMOBJPROPS83 (CMID) select CMID from CMOBJECTS where CLASSID = 4;
  15. !RunCMScript CMUpgradeScript_cognos_roles15_add.xml
  16. !RunCMScript CMUpgradeScript_cognos_roles15_update.xml
  17. !RunCMScript CMUpgradeScript_capabilities_55.xml