| 1234567891011121314151617181920212223242526272829 |
- -- 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 CMOBJPROPS5 add column DETAILTIME timestamp add column DETAIL clob(1M)
- insert into CMOBJPROPS5(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID=78
- CREATE TABLE CMOBJPROPS28 (
- CMID integer not null,
- EVENTKEY clob (4000),
- EVENTTYPES clob (4000),
- constraint PK_CMOBJPROPS28 primary key (CMID)
- )
- insert into CMOBJPROPS11(CMID) SELECT CMID FROM CMOBJECTS WHERE CLASSID=78
- insert into CMOBJPROPS26(CMID) select CMID from CMOBJECTS WHERE (CLASSID=5 OR CLASSID=50 OR CLASSID=52 OR CLASSID=95 OR CLASSID=96 OR CLASSID=97)
- !MigrateRetentionsForHistory
|
