| 123456789101112131415161718 |
- -- 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 lvarchar (256),
- STATUS lvarchar (256),
- STATUSINFO clob,
- PRIMARY KEY (CMID) CONSTRAINT PK_CMOBJPROPS88
- ) lock mode row;
- 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))
|
