dbUpgrade0_9992-to-0_9993_db2.sql 828 B

1234567891011121314151617181920212223242526272829
  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. create table CMOBJPROPS30 (
  12. CMID integer not null,
  13. HANDLE varchar(255),
  14. BINDING clob(1M),
  15. REGISTRATION clob(64K),
  16. SERVICEDESCR clob(1M),
  17. LAYOUT clob(1M),
  18. CONTEXT clob(64K),
  19. constraint PK_CMOBJPROPS30 primary key (CMID)
  20. )
  21. insert into CMOBJPROPS30(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID=5
  22. !RunCMScript CMUpgradeScript_portal_1.xml
  23. !RunCMScript CMUpgradeScript_portal_2.xml