| 1234567891011121314151617181920 |
- -- 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 CMOBJPROPS88 (
- CMID number(10) NOT NULL ,
- SCHEMATYPE varchar2 (256) NULL,
- STATUS varchar2 (256) NULL,
- STATUSINFO clob NULL,
- CONSTRAINT PK_CMOBJPROPS88 PRIMARY KEY (CMID)
- );
- insert into CMOBJPROPS88(CMID, SCHEMATYPE, STATUS, STATUSINFO) select CMID, SCHEMATYPE, STATUS, STATUSINFO from CMOBJPROPS86 where CMID in (select CMID from CMOBJECTS where CLASSID in (259,260));
|
