dbUpgrade7_0038-to-7_0039_db2zOS.sql 636 B

123456789101112131415161718192021
  1. -- Licensed Materials - Property of IBM
  2. --
  3. -- BI and PM: CM
  4. --
  5. -- (C) Copyright IBM Corp. 2016
  6. --
  7. -- US Government Users Restricted Rights - Use, duplication or disclosure
  8. -- restricted by GSA ADP Schedule Contract with IBM Corp.
  9. alter table CMOBJPROPS37 add column PROFILERANK integer with default 0 not null
  10. alter table CMOBJPROPS37 add column PROFILESETTINGS clob (100K)
  11. CREATE AUXILIARY TABLE CMATB129
  12. IN CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML129
  13. STORES CMOBJPROPS37
  14. COLUMN PROFILESETTINGS;
  15. CREATE UNIQUE INDEX CMIDX129 ON CMATB129 USING STOGROUP CMSCRIPT_STOGROUP;
  16. !RunCMScript CMUpgradeScript_system_profile_add.xml