| 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 varchar (512)
- alter table CMOBJPROPS20 add ALLOWNOTIFICATION decimal(1,0)
- CREATE TABLE CMREFORD2 (
- CMID integer not null ,
- ORD integer NOT NULL,
- REFCMID integer 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
|
