| 12345678910111213141516171819 |
- -- 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 integer not null,
- SCHEMATYPE varchar (256),
- STATUS varchar (256),
- STATUSINFO clob(10M),
- CONSTRAINT PK_CMOBJPROPS88 PRIMARY KEY (CMID)
- )
- insert into CMOBJPROPS88(CMID, SCHEMATYPE, STATUS, STATUSINFO) select CMID, varchar(SCHEMATYPE, 256), varchar(STATUS, 256), STATUSINFO from CMOBJPROPS86 where CMID in (select CMID from CMOBJECTS where CLASSID in (259,260))
|
