123456789101112131415161718192021222324 |
- -- 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).
- insert into CMOBJPROPS10(CMID) select CMID from CMOBJECTS where (CLASSID = 51 or CLASSID = 53)
- update CMOBJECTS set CLASSID = 116 where (CLASSID = 51 or CLASSID = 53)
- !MoveDeploymentFolders
- delete from CMOBJPROPS7 where CMID in (select CMID from CMOBJECTS where CLASSID = 75 or CLASSID = 76 or CLASSID = 77)
- update CMOBJECTS set CLASSID = 111 where CLASSID = 75 or CLASSID = 76 or CLASSID = 77
- !AddPISQL "delete from CMREFORD1 where CMID in (select CMID from CMOBJECTS where CLASSID = 75 or CLASSID = 76 or CLASSID = 111)"
|