| 12345678910111213141516171819202122232425262728 |
- -- 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 CMOBJPROPS1 add NOTIFICATIONEMAIL nvarchar (256) NULL
- ALTER TABLE CMOBJPROPS20 add ALLOWNOTIFICATION bit null
- CREATE TABLE CMREFORD2 (
- CMID int NOT NULL,
- ORD int NOT NULL,
- REFCMID int NOT NULL,
- constraint PK_CMREFORD2 primary key (CMID,ORD) )
- INSERT INTO CMREFORD2(CMID, ORD, REFCMID) SELECT CMID, ORD, REFCMID FROM CMREFORD1 WHERE PROPID=35
- create index IDX_CMREFORD2 on CMREFORD2(REFCMID, ORD)
- DELETE FROM CMREFORD1 WHERE PROPID=35
|
