| 123456789101112131415161718192021 |
- -- 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 int NOT NULL,
- SCHEMATYPE varchar (256) null,
- STATUS varchar (256) null,
- STATUSINFO ntext 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))
|
