| 12345678910111213141516171819202122232425262728293031323334353637383940414243 |
- -- 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).
- !MigrateOptions
- drop table CMOBJPROPS19
- alter table CMOBJPROPS7 drop constraint PK_CMOBJPROPS7
- rename CMOBJPROPS7 to CMOBJPROPS7_OLD
- create table CMOBJPROPS7 (
- CMID integer not null,
- EXECERROR clob(1G),
- CONFIGURATION clob(1G),
- PORTALPREFS clob(1G),
- CCREDENTIALS clob(1G),
- CMODEL blob(1G),
- SRC clob(1G),
- SPEC clob(1G),
- STATE clob(1G),
- GOVERNORS clob(1G),
- NAMESPFORMAT clob(4000),
- constraint PK_CMOBJPROPS7 primary key (CMID)
- )
- insert into CMOBJPROPS7(CMID,EXECERROR,CONFIGURATION,PORTALPREFS,CCREDENTIALS,CMODEL,SRC,SPEC,STATE,GOVERNORS,NAMESPFORMAT) select CMID,EXECERROR,CONFIGURATION,PORTALPREFS,CCREDENTIALS,CMODEL,SRC,SPEC,STATE,GOVERNORS,NAMESPFORMAT from CMOBJPROPS7_OLD
- drop table CMOBJPROPS7_OLD
- delete from CMOBJPROPS7 where CMID in (select CMID from CMOBJECTS where CLASSID in(50,52))
|
