-- Licensed Materials - Property of IBM -- -- BI and PM: CM -- -- (C) Copyright IBM Corp. 2011 -- -- US Government Users Restricted Rights - Use, duplication or disclosure -- restricted by GSA ADP Schedule Contract with IBM Corp. create table CMOBJPROPS81 ( CMID integer not null, AGGREGATES clob(1M), CONSTRAINT PK_CMOBJPROPS81 PRIMARY KEY (CMID) ) insert into CMOBJPROPS81 (CMID) select CMID from CMOBJECTS where CLASSID in (237,238,239)