dbUpgrade4_0061-to-4_0062_db2.sql 723 B

1234567891011121314151617181920212223242526
  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 CMOBJPROPS34 add SPEC clob(1G)
  12. alter table CMOBJPROPS34 add TARGETOPTIONS clob(1M)
  13. alter table CMOBJPROPS34 add DEPLOYREFS clob(1M)
  14. create table CMOBJPROPS69 (
  15. CMID integer not null,
  16. ORD integer not null,
  17. PARMNAME varchar(512) not null,
  18. CPARMVALUE blob(1G),
  19. constraint PK_CMOBJPROPS69 primary key (CMID, ORD)
  20. )