dbUpgrade2_0012-to-2_0013_oracle.sql 913 B

123456789101112131415161718192021222324
  1. -- Licensed Materials - Property of IBM
  2. --
  3. -- BI and PM: CM
  4. --
  5. -- (C) Copyright IBM Corp. 2008, 2009
  6. --
  7. -- US Government Users Restricted Rights - Use, duplication or disclosure
  8. -- restricted by GSA ADP Schedule Contract with IBM Corp.
  9. -- Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
  10. -- Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).
  11. insert into CMOBJPROPS10(CMID) select CMID from CMOBJECTS where (CLASSID = 51 or CLASSID = 53)
  12. update CMOBJECTS set CLASSID = 116 where (CLASSID = 51 or CLASSID = 53)
  13. !MoveDeploymentFolders
  14. delete from CMOBJPROPS7 where CMID in (select CMID from CMOBJECTS where CLASSID = 75 or CLASSID = 76 or CLASSID = 77)
  15. update CMOBJECTS set CLASSID = 111 where CLASSID = 75 or CLASSID = 76 or CLASSID = 77
  16. !AddPISQL "delete from CMREFORD1 where CMID in (select CMID from CMOBJECTS where CLASSID = 75 or CLASSID = 76 or CLASSID = 111)"