-- Licensed Materials - Property of IBM -- -- BI and PM: CM -- -- (C) Copyright IBM Corp. 2016 -- -- US Government Users Restricted Rights - Use, duplication or disclosure -- restricted by GSA ADP Schedule Contract with IBM Corp. CREATE TABLE CMARCHIVESTATUS ( CMID int NOT NULL , ARCHSTAT tinyint default(0) not NULL, CONSTRAINT PK_CMARCHIVESTATUS PRIMARY KEY (CMID) ) insert into CMARCHIVESTATUS (CMID) select CMID from CMOBJECTS where CLASSID in (179) insert into CMARCHIVESTATUS (CMID) select CMID from CMOBJECTS where CLASSID in (27)
