123456789101112131415161718192021222324252627 |
- -- Licensed Materials - Property of IBM
- --
- -- BI and PM: CM
- --
- -- (C) Copyright IBM Corp. 2008, 2009
- --
- -- 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).
- alter table CMOBJPROPS26 add DELIVOPTIONS ntext null
- 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))
- CREATE TABLE CMOBJPROPS28 (
- CMID int NOT NULL,
- EVENTKEY ntext NULL,
- EVENTTYPES ntext NULL,
- CONSTRAINT PK_CMOBJPROPS28 PRIMARY KEY (CMID)
- )
- !RunCMScript CMUpgradeScript_transient_1.xml
- !RunCMScript CMUpgradeScript_transient_2.xml
|