analytics/configuration/schemas/content/db2/dbUpgrade0_9996-to-0_9997_db2.sql

-- 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).


create table CMOBJPROPS6A (
	CMID			integer not null,
	BURSTKEY		varchar (3982),
	constraint PK_CMOBJPROPS6A primary key (CMID) 
)

insert into CMOBJPROPS6A(CMID, BURSTKEY) select CMID, cast(BURSTKEY as varchar(3982)) from CMOBJPROPS6 where CMID in (select CMID from CMOBJECTS where CLASSID = 27)

alter table CMOBJPROPS6 drop constraint PK_CMOBJPROPS6

rename CMOBJPROPS6 to CMOBJPROPS6_OLD

create table CMOBJPROPS6 (
	CMID			integer not null,
	URI			clob (4000),
	TARGET			clob (4000),
	STEPOBJECT		clob (4000),
	BASE			clob (4000),
	CREDENTIAL		clob (4000),
	DISPATCHERPATH	varchar (3220),
	PAGE			clob (4000),
	CREDNAMESPACES	clob (4000),
	constraint PK_CMOBJPROPS6 primary key (CMID) 
)

insert into CMOBJPROPS6(CMID, URI, TARGET, STEPOBJECT, BASE, CREDENTIAL, DISPATCHERPATH, PAGE, CREDNAMESPACES) select CMID, URI, TARGET, STEPOBJECT, BASE, CREDENTIAL, DISPATCHERPATH, PAGE, CREDNAMESPACES from CMOBJPROPS6_OLD where CMID in (select CMID from CMOBJECTS where CLASSID <> 27)

drop table CMOBJPROPS6_OLD