dbUpgrade2_0001-to-2_0002_db2.sql 758 B

12345678910111213141516171819202122232425262728
  1. -- Licensed Materials - Property of IBM
  2. --
  3. -- BI and PM: CM
  4. --
  5. -- (C) Copyright IBM Corp. 2008, 2009
  6. --
  7. -- US Government Users Restricted Rights - Use, duplication or disclosure
  8. -- restricted by GSA ADP Schedule Contract with IBM Corp.
  9. -- Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
  10. -- Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).
  11. alter table CMOBJPROPS13 drop constraint CMOBJPROPS13
  12. rename CMOBJPROPS13 to CMOBJPROPS13_OLD
  13. create table CMOBJPROPS13 (
  14. CMID integer not null,
  15. ORD integer not null,
  16. PARMNAME varchar(512) not null,
  17. CPARMVALUE blob(1G),
  18. constraint PK_CMOBJPROPS13 primary key (CMID, ORD)
  19. )
  20. insert into CMOBJPROPS13 select * from CMOBJPROPS13_OLD
  21. drop table CMOBJPROPS13_OLD