| 1234567891011121314151617181920212223 |
- -- Licensed Materials - Property of IBM
- --
- -- BI and PM: CM
- --
- -- (C) Copyright IBM Corp. 2008, 2009
- --
- -- US Government Users Restricted Rights - Use, duplication or disclosure
- -- restricted by GSA ADP Schedule Contract with IBM Corp.
- -- Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
- -- Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).
- CREATE TABLE CMOBJPROPS26 (
- CMID number(10) not null,
- CLOSECONNECTCMD clob null,
- OPENCONNECTCMD clob null,
- CLOSESESSCMD clob null,
- OPENSESSCMD clob null,
- constraint PK_CMOBJPROPS26 primary key (CMID)
- )
- insert into CMOBJPROPS26 (CMID, CLOSECONNECTCMD,OPENCONNECTCMD,CLOSESESSCMD,OPENSESSCMD) select o.CMID, NULL, NULL, NULL, NULL from CMOBJECTS o where (o.CLASSID = 12 or o.CLASSID = 9)
|
