| 12345678910111213141516171819202122 |
- -- 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 CMOBJPROPS16 add ROUTINGTABLE blob(1M)
- create table CMOBJPROPS37 (
- CMID integer not null,
- ROUTINGHINTS clob (4000),
- constraint PK_CMOBJPROPS37 primary key (CMID)
- )
- insert into CMOBJPROPS37(CMID) select CMID from CMOBJECTS WHERE (CLASSID=5 OR CLASSID=18 OR CLASSID=26 OR CLASSID=54)
|
