dbUpgrade2_0009-to-2_0011_mssqlserver.sql 692 B

12345678910111213141516171819202122
  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 CMOBJPROPS16 add ROUTINGTABLE image null
  12. CREATE TABLE CMOBJPROPS37 (
  13. CMID int NOT NULL,
  14. ROUTINGHINTS ntext NULL,
  15. constraint PK_CMOBJPROPS37 primary key (CMID)
  16. )
  17. insert into CMOBJPROPS37(CMID) SELECT CMID FROM CMOBJECTS WHERE (CLASSID = 5 OR CLASSID = 18 OR CLASSID = 26 OR CLASSID = 54)