| 123456789101112131415161718192021222324252627282930 |
- -- 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 CMOBJPROPS27 drop constraint PK_CMOBJPROPS27
- rename CMOBJPROPS27 to CMOBJPROPS27_OLD
- create table CMOBJPROPS27 (
- CMID integer not null,
- CUBECONTNAME varchar (2048),
- GATEWAY varchar (1024),
- HASPROMPTS decimal(1,0) default 0 not null,
- PPOPTIONS clob (4000),
- DATABLOCKS blob(1G),
- constraint PK_CMOBJPROPS27 primary key (CMID)
- )
- insert into CMOBJPROPS27(CMID, CUBECONTNAME, GATEWAY, HASPROMPTS, PPOPTIONS, DATABLOCKS) select CMID, CUBECONTNAME, GATEWAY, HASPROMPTS, PPOPTIONS, DATABLOCKS from CMOBJPROPS27_OLD
- drop table CMOBJPROPS27_OLD
|
