Acasă Explorează Ajutor
Înregistrare Autentificare
GlobalCube
/
analytics
3
0
Bifurcare 0
Fisiere Probleme 0 Trageți solicitările 0 Wiki
Ramură: master
Ramuri Etichete
analytics
/
configuration
/
schemas
/
content
/
sqlserver
/
ResetConfiguration8_3_mssqlserver.sql

ResetConfiguration8_3_mssqlserver.sql 19 KB
Permalink Istoric Crud

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164 
  1. -- Licensed Materials - Property of IBM
    2. 

  2. --
    3. 

  3. -- BI and PM: CM
    4. 

  4. --
    5. 

  5. -- (C) Copyright IBM Corp. 2008, 2009
    6. 

  6. --
    7. 

  7. -- US Government Users Restricted Rights - Use, duplication or disclosure
    8. 

  8. -- restricted by GSA ADP Schedule Contract with IBM Corp.
    9. 

  9. 

  10. -- Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
    11. 

  11. -- Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).
    12. 

  12. 

  13. 

  14. delete from CMOBJNAMES  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    15. 

  15. 

  16. delete from CMDATA  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    17. 

  17. 

  18. delete from CMSTOREIDS  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    19. 

  19. 

  20. delete from CMOBJPROPS1  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    21. 

  21. 

  22. delete from CMOBJPROPS10  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    23. 

  23. 

  24. delete from CMOBJPROPS11  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    25. 

  25. 

  26. delete from CMOBJPROPS13  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    27. 

  27. 

  28. delete from CMOBJPROPS14  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    29. 

  29. 

  30. delete from CMOBJPROPS15  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    31. 

  31. 

  32. delete from CMOBJPROPS16  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    33. 

  33. 

  34. delete from CMOBJPROPS17  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    35. 

  35. 

  36. delete from CMOBJPROPS18  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    37. 

  37. 

  38. delete from CMOBJPROPS2  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    39. 

  39. 

  40. delete from CMOBJPROPS20  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    41. 

  41. 

  42. delete from CMOBJPROPS23  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    43. 

  43. 

  44. delete from CMOBJPROPS24  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    45. 

  45. 

  46. delete from CMOBJPROPS25  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    47. 

  47. 

  48. delete from CMOBJPROPS26  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    49. 

  49. 

  50. delete from CMOBJPROPS27  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    51. 

  51. 

  52. delete from CMOBJPROPS28  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    53. 

  53. 

  54. delete from CMOBJPROPS3  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    55. 

  55. 

  56. delete from CMOBJPROPS30  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    57. 

  57. 

  58. delete from CMOBJPROPS31  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    59. 

  59. 

  60. delete from CMOBJPROPS32  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    61. 

  61. 

  62. delete from CMOBJPROPS33  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    63. 

  63. 

  64. delete from CMOBJPROPS34  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    65. 

  65. 

  66. delete from CMOBJPROPS35  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    67. 

  67. 

  68. delete from CMOBJPROPS36  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    69. 

  69. 

  70. delete from CMOBJPROPS37  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    71. 

  71. 

  72. delete from CMOBJPROPS38  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    73. 

  73. 

  74. delete from CMOBJPROPS39  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    75. 

  75. 

  76. delete from CMOBJPROPS4  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    77. 

  77. 

  78. delete from CMOBJPROPS40  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    79. 

  79. 

  80. delete from CMOBJPROPS41  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    81. 

  81. 

  82. delete from CMOBJPROPS42  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    83. 

  83. 

  84. delete from CMOBJPROPS43  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    85. 

  85. 

  86. delete from CMOBJPROPS44  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    87. 

  87. 

  88. delete from CMOBJPROPS45  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    89. 

  89. 

  90. delete from CMOBJPROPS46  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    91. 

  91. 

  92. delete from CMOBJPROPS47  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    93. 

  93. 

  94. delete from CMOBJPROPS48  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    95. 

  95. 

  96. delete from CMOBJPROPS49  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    97. 

  97. 

  98. delete from CMOBJPROPS5  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    99. 

  99. 

  100. delete from CMOBJPROPS50  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    101. 

  101. 

  102. delete from CMOBJPROPS51  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    103. 

  103. 

  104. delete from CMOBJPROPS52  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    105. 

  105. 

  106. delete from CMOBJPROPS53  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    107. 

  107. 

  108. delete from CMOBJPROPS54  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    109. 

  109. 

  110. delete from CMOBJPROPS55  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    111. 

  111. 

  112. delete from CMOBJPROPS56  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    113. 

  113. 

  114. delete from CMOBJPROPS57  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    115. 

  115. 

  116. delete from CMOBJPROPS58  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    117. 

  117. 

  118. delete from CMOBJPROPS59  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    119. 

  119. 

  120. delete from CMOBJPROPS6  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    121. 

  121. 

  122. delete from CMOBJPROPS60  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    123. 

  123. 

  124. delete from CMOBJPROPS61  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    125. 

  125. 

  126. delete from CMOBJPROPS62  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    127. 

  127. 

  128. delete from CMOBJPROPS63  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    129. 

  129. 

  130. delete from CMOBJPROPS64  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    131. 

  131. 

  132. delete from CMOBJPROPS65  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    133. 

  133. 

  134. delete from CMOBJPROPS66  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    135. 

  135. 

  136. delete from CMOBJPROPS67  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    137. 

  137. 

  138. delete from CMOBJPROPS68  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    139. 

  139. 

  140. delete from CMOBJPROPS69  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    141. 

  141. 

  142. delete from CMOBJPROPS7  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    143. 

  143. 

  144. delete from CMOBJPROPS9  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    145. 

  145. 

  146. delete from CMPOLICIES  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    147. 

  147. 

  148. delete from CMVIEWED  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    149. 

  149. 

  150. delete from CMGUIDS  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    151. 

  151. 

  152. delete from  CMREFNOORD1  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    153. 

  153. 

  154. delete from  CMREFNOORD2  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    155. 

  155. 

  156. delete from  CMREFORD1  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    157. 

  157. 

  158. delete from  CMREFORD2  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    159. 

  159. 

  160. delete from CMSIZEINFO  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    161. 

  161. 

  162. delete from CMOBJECTS  where CMID in (select CMID from CMOBJECTS where CLASSID=14 or PCMID in ( select CMID from CMOBJECTS where CLASSID=14 ) or PCMID in ( select CMID from CMOBJECTS where PCMID in ( select CMID from CMOBJECTS where CLASSID=14 )))
    163. 

  163. 

  164. update CMCAPACITY set CMPATH='' where USAGE=4
    165.