You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by db...@apache.org on 2016/12/14 00:17:34 UTC
[16/22] incubator-trafodion-site git commit: Merge [TRAFODION-2389]
PR 877 into web site
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/28f31b1c/docs/2.1.0/messages_guide/index.html
----------------------------------------------------------------------
diff --git a/docs/2.1.0/messages_guide/index.html b/docs/2.1.0/messages_guide/index.html
index 4785acd..48ede62 100644
--- a/docs/2.1.0/messages_guide/index.html
+++ b/docs/2.1.0/messages_guide/index.html
@@ -560,36 +560,36 @@ table.CodeRay td.code>pre{padding:0}
</li>
<li><a href="#data-definition-language-messages">3. Data Definition Language (DDL) Messages (1000 through 1999)</a>
<ul class="sectlevel2">
-<li><a href="#SQL-1002">3.1. SQL 1002</a></li>
-<li><a href="#SQL-1003">3.2. SQL 1003</a></li>
-<li><a href="#SQL-1004">3.3. SQL 1004</a></li>
-<li><a href="#SQL-1005">3.4. SQL 1005</a></li>
-<li><a href="#SQL-1007">3.5. SQL 1007</a></li>
-<li><a href="#SQL-1008">3.6. SQL 1008</a></li>
-<li><a href="#SQL-1009">3.7. SQL 1009</a></li>
-<li><a href="#SQL-1010">3.8. SQL 1010</a></li>
-<li><a href="#SQL-1011">3.9. SQL 1011</a></li>
-<li><a href="#SQL-1012">3.10. SQL 1012</a></li>
-<li><a href="#SQL-1013">3.11. SQL 1013</a></li>
-<li><a href="#SQL-1015">3.12. SQL 1015</a></li>
-<li><a href="#SQL-1016">3.13. SQL 1016</a></li>
-<li><a href="#SQL-1017">3.14. SQL 1017</a></li>
-<li><a href="#SQL-1020">3.15. SQL 1020</a></li>
-<li><a href="#SQL-1021">3.16. SQL 1021</a></li>
-<li><a href="#SQL-1022">3.17. SQL 1022</a></li>
-<li><a href="#SQL-1023">3.18. SQL 1023</a></li>
-<li><a href="#SQL-1024">3.19. SQL 1024</a></li>
+<li><a href="#SQL-1001">3.1. SQL 1001</a></li>
+<li><a href="#SQL-1002">3.2. SQL 1002</a></li>
+<li><a href="#SQL-1003">3.3. SQL 1003</a></li>
+<li><a href="#SQL-1004">3.4. SQL 1004</a></li>
+<li><a href="#SQL-1005">3.5. SQL 1005</a></li>
+<li><a href="#SQL-1007">3.6. SQL 1007</a></li>
+<li><a href="#SQL-1008">3.7. SQL 1008</a></li>
+<li><a href="#SQL-1009">3.8. SQL 1009</a></li>
+<li><a href="#SQL-1010">3.9. SQL 1010</a></li>
+<li><a href="#SQL-1011">3.10. SQL 1011</a></li>
+<li><a href="#SQL-1012">3.11. SQL 1012</a></li>
+<li><a href="#SQL-1013">3.12. SQL 1013</a></li>
+<li><a href="#SQL-1015">3.13. SQL 1015</a></li>
+<li><a href="#SQL-1016">3.14. SQL 1016</a></li>
+<li><a href="#SQL-1017">3.15. SQL 1017</a></li>
+<li><a href="#SQL-1018">3.16. SQL 1018</a></li>
+<li><a href="#SQL-1020">3.17. SQL 1020</a></li>
+<li><a href="#SQL-1021">3.18. SQL 1021</a></li>
+<li><a href="#SQL-1022">3.19. SQL 1022</a></li>
<li><a href="#SQL-1025">3.20. SQL 1025</a></li>
-<li><a href="#SQL-1026">3.21. SQL 1026</a></li>
-<li><a href="#SQL-1027">3.22. SQL 1027</a></li>
-<li><a href="#SQL-1028">3.23. SQL 1028</a></li>
-<li><a href="#SQL-1029">3.24. SQL 1029</a></li>
-<li><a href="#SQL-1030">3.25. SQL 1030</a></li>
-<li><a href="#SQL-1031">3.26. SQL 1031</a></li>
-<li><a href="#SQL-1035">3.27. SQL 1035</a></li>
-<li><a href="#SQL-1036">3.28. SQL 1036</a></li>
-<li><a href="#SQL-1037">3.29. SQL 1037</a></li>
-<li><a href="#SQL-1038">3.30. SQL 1038</a></li>
+<li><a href="#SQL-1027">3.21. SQL 1027</a></li>
+<li><a href="#SQL-1028">3.22. SQL 1028</a></li>
+<li><a href="#SQL-1029">3.23. SQL 1029</a></li>
+<li><a href="#SQL-1030">3.24. SQL 1030</a></li>
+<li><a href="#SQL-1031">3.25. SQL 1031</a></li>
+<li><a href="#SQL-1032">3.26. SQL 1032</a></li>
+<li><a href="#SQL-1034">3.27. SQL 1034</a></li>
+<li><a href="#SQL-1035">3.28. SQL 1035</a></li>
+<li><a href="#SQL-1036">3.29. SQL 1036</a></li>
+<li><a href="#SQL-1037">3.30. SQL 1037</a></li>
<li><a href="#SQL-1039">3.31. SQL 1039</a></li>
<li><a href="#SQL-1040">3.32. SQL 1040</a></li>
<li><a href="#SQL-1041">3.33. SQL 1041</a></li>
@@ -603,143 +603,129 @@ table.CodeRay td.code>pre{padding:0}
<li><a href="#SQL-1049">3.41. SQL 1049</a></li>
<li><a href="#SQL-1050">3.42. SQL 1050</a></li>
<li><a href="#SQL-1051">3.43. SQL 1051</a></li>
-<li><a href="#SQL-1053">3.44. SQL 1053</a></li>
-<li><a href="#SQL-1057">3.45. SQL 1057</a></li>
-<li><a href="#SQL-1058">3.46. SQL 1058</a></li>
-<li><a href="#SQL-1059">3.47. SQL 1059</a></li>
-<li><a href="#SQL-1061">3.48. SQL 1061</a></li>
+<li><a href="#SQL-1052">3.44. SQL 1052</a></li>
+<li><a href="#SQL-1053">3.45. SQL 1053</a></li>
+<li><a href="#SQL-1055">3.46. SQL 1055</a></li>
+<li><a href="#SQL-1058">3.47. SQL 1058</a></li>
+<li><a href="#SQL-1059">3.48. SQL 1059</a></li>
<li><a href="#SQL-1062">3.49. SQL 1062</a></li>
-<li><a href="#SQL-1063">3.50. SQL 1063</a></li>
-<li><a href="#SQL-1064">3.51. SQL 1064</a></li>
-<li><a href="#SQL-1065">3.52. SQL 1065</a></li>
-<li><a href="#SQL-1066">3.53. SQL 1066</a></li>
-<li><a href="#SQL-1069">3.54. SQL 1069</a></li>
-<li><a href="#SQL-1070">3.55. SQL 1070</a></li>
-<li><a href="#SQL-1071">3.56. SQL 1071</a></li>
-<li><a href="#SQL-1072">3.57. SQL 1072</a></li>
-<li><a href="#SQL-1073">3.58. SQL 1073</a></li>
-<li><a href="#SQL-1075">3.59. SQL 1075</a></li>
-<li><a href="#SQL-1078">3.60. SQL 1078</a></li>
-<li><a href="#SQL-1079">3.61. SQL 1079</a></li>
-<li><a href="#SQL-1080">3.62. SQL 1080</a></li>
-<li><a href="#SQL-1081">3.63. SQL 1081</a></li>
-<li><a href="#SQL-1082">3.64. SQL 1082</a></li>
-<li><a href="#SQL-1083">3.65. SQL 1083</a></li>
-<li><a href="#SQL-1084">3.66. SQL 1084</a></li>
-<li><a href="#SQL-1085">3.67. SQL 1085</a></li>
-<li><a href="#SQL-1086">3.68. SQL 1086</a></li>
-<li><a href="#SQL-1087">3.69. SQL 1087</a></li>
-<li><a href="#SQL-1088">3.70. SQL 1088</a></li>
-<li><a href="#SQL-1089">3.71. SQL 1089</a></li>
-<li><a href="#SQL-1090">3.72. SQL 1090</a></li>
-<li><a href="#SQL-1094">3.73. SQL 1094</a></li>
-<li><a href="#SQL-1095">3.74. SQL 1095</a></li>
-<li><a href="#SQL-1098">3.75. SQL 1098</a></li>
-<li><a href="#SQL-1099">3.76. SQL 1099</a></li>
-<li><a href="#SQL-1104">3.77. SQL 1104</a></li>
-<li><a href="#SQL-1105">3.78. SQL 1105</a></li>
-<li><a href="#SQL-1106">3.79. SQL 1106</a></li>
-<li><a href="#SQL-1108">3.80. SQL 1108</a></li>
-<li><a href="#SQL-1109">3.81. SQL 1109</a></li>
-<li><a href="#SQL-1112">3.82. SQL 1112</a></li>
-<li><a href="#SQL-1114">3.83. SQL 1114</a></li>
-<li><a href="#SQL-1115">3.84. SQL 1115</a></li>
-<li><a href="#SQL-1116">3.85. SQL 1116</a></li>
-<li><a href="#SQL-1117">3.86. SQL 1117</a></li>
-<li><a href="#SQL-1118">3.87. SQL 1118</a></li>
-<li><a href="#SQL-1119">3.88. SQL 1119</a></li>
-<li><a href="#SQL-1120">3.89. SQL 1120</a></li>
-<li><a href="#SQL-1121">3.90. SQL 1121</a></li>
-<li><a href="#SQL-1122">3.91. SQL 1122</a></li>
-<li><a href="#SQL-1123">3.92. SQL 1123</a></li>
-<li><a href="#SQL-1124">3.93. SQL 1124</a></li>
-<li><a href="#SQL-1127">3.94. SQL 1127</a></li>
-<li><a href="#SQL-1130">3.95. SQL 1130</a></li>
-<li><a href="#SQL-1132">3.96. SQL 1132</a></li>
-<li><a href="#SQL-1133">3.97. SQL 1133</a></li>
-<li><a href="#SQL-1134">3.98. SQL 1134</a></li>
-<li><a href="#SQL-1135">3.99. SQL 1135</a></li>
-<li><a href="#SQL-1136">3.100. SQL 1136</a></li>
-<li><a href="#SQL-1139">3.101. SQL 1139</a></li>
-<li><a href="#SQL-1140">3.102. SQL 1140</a></li>
-<li><a href="#SQL-1141">3.103. SQL 1141</a></li>
-<li><a href="#SQL-1142">3.104. SQL 1142</a></li>
-<li><a href="#SQL-1143">3.105. SQL 1143</a></li>
-<li><a href="#SQL-1144">3.106. SQL 1144</a></li>
-<li><a href="#SQL-1145">3.107. SQL 1145</a></li>
-<li><a href="#SQL-1146">3.108. SQL 1146</a></li>
-<li><a href="#SQL-1147">3.109. SQL 1147</a></li>
-<li><a href="#SQL-1148">3.110. SQL 1148</a></li>
-<li><a href="#SQL-1150">3.111. SQL 1150</a></li>
-<li><a href="#SQL-1151">3.112. SQL 1151</a></li>
-<li><a href="#SQL-1154">3.113. SQL 1154</a></li>
-<li><a href="#SQL-1155">3.114. SQL 1155</a></li>
-<li><a href="#SQL-1156">3.115. SQL 1156</a></li>
-<li><a href="#SQL-1157">3.116. SQL 1157</a></li>
-<li><a href="#SQL-1158">3.117. SQL 1158</a></li>
-<li><a href="#SQL-1159">3.118. SQL 1159</a></li>
-<li><a href="#SQL-1160">3.119. SQL 1160</a></li>
-<li><a href="#SQL-1161">3.120. SQL 1161</a></li>
-<li><a href="#SQL-1180">3.121. SQL 1180</a></li>
-<li><a href="#SQL-1181">3.122. SQL 1181</a></li>
-<li><a href="#SQL-1182">3.123. SQL 1182</a></li>
-<li><a href="#SQL-1183">3.124. SQL 1183</a></li>
-<li><a href="#SQL-1184">3.125. SQL 1184</a></li>
-<li><a href="#SQL-1185">3.126. SQL 1185</a></li>
-<li><a href="#SQL-1186">3.127. SQL 1186</a></li>
-<li><a href="#SQL-1187">3.128. SQL 1187</a></li>
-<li><a href="#SQL-1188">3.129. SQL 1188</a></li>
-<li><a href="#SQL-1224">3.130. SQL 1224</a></li>
-<li><a href="#SQL-1225">3.131. SQL 1225</a></li>
-<li><a href="#SQL-1226">3.132. SQL 1226</a></li>
-<li><a href="#SQL-1231">3.133. SQL 1231</a></li>
-<li><a href="#SQL-1232">3.134. SQL 1232</a></li>
-<li><a href="#SQL-1233">3.135. SQL 1233</a></li>
-<li><a href="#SQL-1235">3.136. SQL 1235</a></li>
-<li><a href="#SQL-1236">3.137. SQL 1236</a></li>
-<li><a href="#SQL-1238">3.138. SQL 1238</a></li>
-<li><a href="#SQL-1239">3.139. SQL 1239</a></li>
-<li><a href="#SQL-1240">3.140. SQL 1240</a></li>
-<li><a href="#SQL-1241">3.141. SQL 1241</a></li>
-<li><a href="#SQL-1242">3.142. SQL 1242</a></li>
-<li><a href="#SQL-1243">3.143. SQL 1243</a></li>
-<li><a href="#SQL-1245">3.144. SQL 1245</a></li>
-<li><a href="#SQL-1246">3.145. SQL 1246</a></li>
-<li><a href="#SQL-1248">3.146. SQL 1248</a></li>
-<li><a href="#SQL-1250">3.147. SQL 1250</a></li>
-<li><a href="#SQL-1251">3.148. SQL 1251</a></li>
-<li><a href="#SQL-1252">3.149. SQL 1252</a></li>
-<li><a href="#SQL-1254">3.150. SQL 1254</a></li>
-<li><a href="#SQL-1262">3.151. SQL 1262</a></li>
-<li><a href="#SQL-1263">3.152. SQL 1263</a></li>
-<li><a href="#SQL-1264">3.153. SQL 1264</a></li>
-<li><a href="#SQL-1265">3.154. SQL 1265</a></li>
-<li><a href="#SQL-1266">3.155. SQL 1266</a></li>
-<li><a href="#SQL-1267">3.156. SQL 1267</a></li>
-<li><a href="#SQL-1268">3.157. SQL 1268</a></li>
-<li><a href="#SQL-1270">3.158. SQL 1270</a></li>
-<li><a href="#SQL-1271">3.159. SQL 1271</a></li>
-<li><a href="#SQL-1273">3.160. SQL 1273</a></li>
-<li><a href="#SQL-1274">3.161. SQL 1274</a></li>
-<li><a href="#SQL-1275">3.162. SQL 1275</a></li>
-<li><a href="#SQL-1277">3.163. SQL 1277</a></li>
-<li><a href="#SQL-1278">3.164. SQL 1278</a></li>
-<li><a href="#SQL-1301">3.165. SQL 1301</a></li>
-<li><a href="#SQL-1302">3.166. SQL 1302</a></li>
-<li><a href="#SQL-1305">3.167. SQL 1305</a></li>
-<li><a href="#SQL-1307">3.168. SQL 1307</a></li>
-<li><a href="#SQL-1309">3.169. SQL 1309</a></li>
-<li><a href="#SQL-1310">3.170. SQL 1310</a></li>
-<li><a href="#SQL-1420">3.171. SQL 1420</a></li>
-<li><a href="#SQL-1421">3.172. SQL 1421</a></li>
-<li><a href="#SQL-1422">3.173. SQL 1422</a></li>
-<li><a href="#SQL-1423">3.174. SQL 1423</a></li>
-<li><a href="#SQL-1424">3.175. SQL 1424</a></li>
-<li><a href="#SQL-1425">3.176. SQL 1425</a></li>
-<li><a href="#SQL-1426">3.177. SQL 1426</a></li>
-<li><a href="#SQL-1427">3.178. SQL 1427</a></li>
-<li><a href="#SQL-1428">3.179. SQL 1428</a></li>
-<li><a href="#SQL-1429">3.180. SQL 1429</a></li>
+<li><a href="#SQL-1068">3.50. SQL 1068</a></li>
+<li><a href="#SQL-1069">3.51. SQL 1069</a></li>
+<li><a href="#SQL-1070">3.52. SQL 1070</a></li>
+<li><a href="#SQL-1073">3.53. SQL 1073</a></li>
+<li><a href="#SQL-1080">3.54. SQL 1080</a></li>
+<li><a href="#SQL-1081">3.55. SQL 1081</a></li>
+<li><a href="#SQL-1082">3.56. SQL 1082</a></li>
+<li><a href="#SQL-1083">3.57. SQL 1083</a></li>
+<li><a href="#SQL-1084">3.58. SQL 1084</a></li>
+<li><a href="#SQL-1089">3.59. SQL 1089</a></li>
+<li><a href="#SQL-1090">3.60. SQL 1090</a></li>
+<li><a href="#SQL-1098">3.61. SQL 1098</a></li>
+<li><a href="#SQL-1099">3.62. SQL 1099</a></li>
+<li><a href="#SQL-1104">3.63. SQL 1104</a></li>
+<li><a href="#SQL-1105">3.64. SQL 1105</a></li>
+<li><a href="#SQL-1106">3.65. SQL 1106</a></li>
+<li><a href="#SQL-1108">3.66. SQL 1108</a></li>
+<li><a href="#SQL-1109">3.67. SQL 1109</a></li>
+<li><a href="#SQL-1112">3.68. SQL 1112</a></li>
+<li><a href="#SQL-1114">3.69. SQL 1114</a></li>
+<li><a href="#SQL-1115">3.70. SQL 1115</a></li>
+<li><a href="#SQL-1116">3.71. SQL 1116</a></li>
+<li><a href="#SQL-1117">3.72. SQL 1117</a></li>
+<li><a href="#SQL-1118">3.73. SQL 1118</a></li>
+<li><a href="#SQL-1119">3.74. SQL 1119</a></li>
+<li><a href="#SQL-1120">3.75. SQL 1120</a></li>
+<li><a href="#SQL-1121">3.76. SQL 1121</a></li>
+<li><a href="#SQL-1122">3.77. SQL 1122</a></li>
+<li><a href="#SQL-1123">3.78. SQL 1123</a></li>
+<li><a href="#SQL-1124">3.79. SQL 1124</a></li>
+<li><a href="#SQL-1127">3.80. SQL 1127</a></li>
+<li><a href="#SQL-1130">3.81. SQL 1130</a></li>
+<li><a href="#SQL-1132">3.82. SQL 1132</a></li>
+<li><a href="#SQL-1133">3.83. SQL 1133</a></li>
+<li><a href="#SQL-1134">3.84. SQL 1134</a></li>
+<li><a href="#SQL-1135">3.85. SQL 1135</a></li>
+<li><a href="#SQL-1136">3.86. SQL 1136</a></li>
+<li><a href="#SQL-1139">3.87. SQL 1139</a></li>
+<li><a href="#SQL-1140">3.88. SQL 1140</a></li>
+<li><a href="#SQL-1141">3.89. SQL 1141</a></li>
+<li><a href="#SQL-1142">3.90. SQL 1142</a></li>
+<li><a href="#SQL-1143">3.91. SQL 1143</a></li>
+<li><a href="#SQL-1144">3.92. SQL 1144</a></li>
+<li><a href="#SQL-1145">3.93. SQL 1145</a></li>
+<li><a href="#SQL-1146">3.94. SQL 1146</a></li>
+<li><a href="#SQL-1147">3.95. SQL 1147</a></li>
+<li><a href="#SQL-1148">3.96. SQL 1148</a></li>
+<li><a href="#SQL-1150">3.97. SQL 1150</a></li>
+<li><a href="#SQL-1151">3.98. SQL 1151</a></li>
+<li><a href="#SQL-1154">3.99. SQL 1154</a></li>
+<li><a href="#SQL-1155">3.100. SQL 1155</a></li>
+<li><a href="#SQL-1156">3.101. SQL 1156</a></li>
+<li><a href="#SQL-1157">3.102. SQL 1157</a></li>
+<li><a href="#SQL-1158">3.103. SQL 1158</a></li>
+<li><a href="#SQL-1159">3.104. SQL 1159</a></li>
+<li><a href="#SQL-1160">3.105. SQL 1160</a></li>
+<li><a href="#SQL-1161">3.106. SQL 1161</a></li>
+<li><a href="#SQL-1180">3.107. SQL 1180</a></li>
+<li><a href="#SQL-1181">3.108. SQL 1181</a></li>
+<li><a href="#SQL-1182">3.109. SQL 1182</a></li>
+<li><a href="#SQL-1183">3.110. SQL 1183</a></li>
+<li><a href="#SQL-1184">3.111. SQL 1184</a></li>
+<li><a href="#SQL-1185">3.112. SQL 1185</a></li>
+<li><a href="#SQL-1186">3.113. SQL 1186</a></li>
+<li><a href="#SQL-1187">3.114. SQL 1187</a></li>
+<li><a href="#SQL-1188">3.115. SQL 1188</a></li>
+<li><a href="#SQL-1224">3.116. SQL 1224</a></li>
+<li><a href="#SQL-1225">3.117. SQL 1225</a></li>
+<li><a href="#SQL-1226">3.118. SQL 1226</a></li>
+<li><a href="#SQL-1231">3.119. SQL 1231</a></li>
+<li><a href="#SQL-1232">3.120. SQL 1232</a></li>
+<li><a href="#SQL-1233">3.121. SQL 1233</a></li>
+<li><a href="#SQL-1235">3.122. SQL 1235</a></li>
+<li><a href="#SQL-1236">3.123. SQL 1236</a></li>
+<li><a href="#SQL-1238">3.124. SQL 1238</a></li>
+<li><a href="#SQL-1239">3.125. SQL 1239</a></li>
+<li><a href="#SQL-1240">3.126. SQL 1240</a></li>
+<li><a href="#SQL-1241">3.127. SQL 1241</a></li>
+<li><a href="#SQL-1242">3.128. SQL 1242</a></li>
+<li><a href="#SQL-1243">3.129. SQL 1243</a></li>
+<li><a href="#SQL-1245">3.130. SQL 1245</a></li>
+<li><a href="#SQL-1246">3.131. SQL 1246</a></li>
+<li><a href="#SQL-1248">3.132. SQL 1248</a></li>
+<li><a href="#SQL-1250">3.133. SQL 1250</a></li>
+<li><a href="#SQL-1251">3.134. SQL 1251</a></li>
+<li><a href="#SQL-1252">3.135. SQL 1252</a></li>
+<li><a href="#SQL-1254">3.136. SQL 1254</a></li>
+<li><a href="#SQL-1262">3.137. SQL 1262</a></li>
+<li><a href="#SQL-1263">3.138. SQL 1263</a></li>
+<li><a href="#SQL-1264">3.139. SQL 1264</a></li>
+<li><a href="#SQL-1265">3.140. SQL 1265</a></li>
+<li><a href="#SQL-1266">3.141. SQL 1266</a></li>
+<li><a href="#SQL-1267">3.142. SQL 1267</a></li>
+<li><a href="#SQL-1268">3.143. SQL 1268</a></li>
+<li><a href="#SQL-1270">3.144. SQL 1270</a></li>
+<li><a href="#SQL-1271">3.145. SQL 1271</a></li>
+<li><a href="#SQL-1273">3.146. SQL 1273</a></li>
+<li><a href="#SQL-1274">3.147. SQL 1274</a></li>
+<li><a href="#SQL-1275">3.148. SQL 1275</a></li>
+<li><a href="#SQL-1277">3.149. SQL 1277</a></li>
+<li><a href="#SQL-1278">3.150. SQL 1278</a></li>
+<li><a href="#SQL-1301">3.151. SQL 1301</a></li>
+<li><a href="#SQL-1302">3.152. SQL 1302</a></li>
+<li><a href="#SQL-1305">3.153. SQL 1305</a></li>
+<li><a href="#SQL-1307">3.154. SQL 1307</a></li>
+<li><a href="#SQL-1309">3.155. SQL 1309</a></li>
+<li><a href="#SQL-1310">3.156. SQL 1310</a></li>
+<li><a href="#SQL-1420">3.157. SQL 1420</a></li>
+<li><a href="#SQL-1421">3.158. SQL 1421</a></li>
+<li><a href="#SQL-1422">3.159. SQL 1422</a></li>
+<li><a href="#SQL-1423">3.160. SQL 1423</a></li>
+<li><a href="#SQL-1424">3.161. SQL 1424</a></li>
+<li><a href="#SQL-1425">3.162. SQL 1425</a></li>
+<li><a href="#SQL-1426">3.163. SQL 1426</a></li>
+<li><a href="#SQL-1427">3.164. SQL 1427</a></li>
+<li><a href="#SQL-1428">3.165. SQL 1428</a></li>
+<li><a href="#SQL-1429">3.166. SQL 1429</a></li>
</ul>
</li>
<li><a href="#trafodion-compiler-messages">4. Trafodion Compiler Messages (2000 through 2999)</a>
@@ -1803,7 +1789,33 @@ SQLCODE values for Trafodion warning and error messages.</p>
<h2 id="data-definition-language-messages">3. Data Definition Language (DDL) Messages (1000 through 1999)</h2>
<div class="sectionbody">
<div class="sect2">
-<h3 id="SQL-1002">3.1. SQL 1002</h3>
+<h3 id="SQL-1001">3.1. SQL 1001</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">An internal error occurred in module <module-name> on line <line-number>. Details(<details>).</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p>Where <module-name> is the name of a Trafodion source code module.</p>
+</div>
+<div class="paragraph">
+<p>Where <line-number> is the number of a line within the source code module.</p>
+</div>
+<div class="paragraph">
+<p>Where <details> gives additional information as to the error.</p>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> An internal error occurred in the Trafodion software.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> None. Contact the Trafodion Developer Distribution List.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-1002">3.2. SQL 1002</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Catalog <catalog> does not exist.</code></pre>
@@ -1821,9 +1833,10 @@ SQLCODE values for Trafodion warning and error messages.</p>
<div class="paragraph">
<p><strong>Recovery:</strong> Enter a valid catalog name and resubmit.</p>
</div>
+<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1003">3.2. SQL 1003</h3>
+<h3 id="SQL-1003">3.3. SQL 1003</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Schema <schema> does not exist.</code></pre>
@@ -1842,13 +1855,12 @@ specified a schema that does not exist.</p>
<div class="paragraph">
<p><strong>Recovery:</strong> Check that a schema named <schema> does exist and resubmit.</p>
</div>
-<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1004">3.3. SQL 1004</h3>
+<h3 id="SQL-1004">3.4. SQL 1004</h3>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">Table, view, or stored procedure <object-name> does not exist or object type is invalid for the current operation.</code></pre>
+<pre class="CodeRay highlight"><code data-lang="text">Object <object-name> does not exist or object type is invalid for the current operation.</code></pre>
</div>
</div>
<div class="paragraph">
@@ -1865,9 +1877,10 @@ specified a schema that does not exist.</p>
did not fully qualify the name, check that the defaults generate the
correct fully qualified name and resubmit.</p>
</div>
+<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1005">3.4. SQL 1005</h3>
+<h3 id="SQL-1005">3.5. SQL 1005</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Constraint <constraint-name> does not exist.</code></pre>
@@ -1889,10 +1902,9 @@ of a constraint named <constraint-name>.</p>
the table specified. You can use the SHOWDDL command to find the names
of the constraints that exist on a table.</p>
</div>
-<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1007">3.5. SQL 1007</h3>
+<h3 id="SQL-1007">3.6. SQL 1007</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">The WITH GRANT OPTION is not supported.</code></pre>
@@ -1908,9 +1920,10 @@ the WITH GRANT OPTION. This is not allowed.</p>
<div class="paragraph">
<p><strong>Recovery:</strong> Remove the WITH GRANT OPTION clause and resubmit.</p>
</div>
+<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1008">3.6. SQL 1008</h3>
+<h3 id="SQL-1008">3.7. SQL 1008</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Authorization identifier <auth-id> does not exist.</code></pre>
@@ -1930,10 +1943,9 @@ valid Trafodion platform user or role.</p>
<div class="paragraph">
<p><strong>Recovery:</strong> Correct the name and resubmit.</p>
</div>
-<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1009">3.7. SQL 1009</h3>
+<h3 id="SQL-1009">3.8. SQL 1009</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Column <column-name> does not exist in the specified table.</code></pre>
@@ -1953,9 +1965,10 @@ name.</p>
<p><strong>Recovery:</strong> Replace either the name of the table or the name of the
column (whichever is incorrect) and resubmit.</p>
</div>
+<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1010">3.8. SQL 1010</h3>
+<h3 id="SQL-1010">3.9. SQL 1010</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">The statement just entered is currently not supported.</code></pre>
@@ -1970,10 +1983,9 @@ column (whichever is incorrect) and resubmit.</p>
<div class="paragraph">
<p><strong>Recovery:</strong> Do not attempt to use this Trafodion database statement.</p>
</div>
-<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1011">3.9. SQL 1011</h3>
+<h3 id="SQL-1011">3.10. SQL 1011</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Only one grantee per grant or revoke is allowed.</code></pre>
@@ -1991,7 +2003,7 @@ This is currently not supported.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1012">3.10. SQL 1012</h3>
+<h3 id="SQL-1012">3.11. SQL 1012</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">No privileges were granted. You lack grant option on the specified privileges.</code></pre>
@@ -2007,12 +2019,13 @@ grant options.</p>
<div class="paragraph">
<p><strong>Recovery:</strong> You must have grant options for privileges to grant them.</p>
</div>
+<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1013">3.11. SQL 1013</h3>
+<h3 id="SQL-1013">3.12. SQL 1013</h3>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">Not all privileges were granted. You lack grant option for the <privilege> privilege.</code></pre>
+<pre class="CodeRay highlight"><code data-lang="text">Not all privileges were granted. You lack grant option for the <privilege> privilege.</code></pre>
</div>
</div>
<div class="paragraph">
@@ -2029,10 +2042,9 @@ that you attempted to grant.</p>
<div class="paragraph">
<p><strong>Recovery:</strong> You must have grant options for privileges to grant them.</p>
</div>
-<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1015">3.12. SQL 1015</h3>
+<h3 id="SQL-1015">3.13. SQL 1015</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Not all privileges were revoked. You lack the grant option for the <privilege> privilege.</code></pre>
@@ -2054,7 +2066,7 @@ was granted by another user.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1016">3.13. SQL 1016</h3>
+<h3 id="SQL-1016">3.14. SQL 1016</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Redundant references to column <column-name> were specified in the constraint or trigger definition.</code></pre>
@@ -2075,7 +2087,7 @@ was granted by another user.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1017">3.14. SQL 1017</h3>
+<h3 id="SQL-1017">3.15. SQL 1017</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">You are not authorized to perform this operation.</code></pre>
@@ -2097,7 +2109,31 @@ perform a replication operation for a single schema.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1020">3.15. SQL 1020</h3>
+<h3 id="SQL-1018">3.16. SQL 1018</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Grant of role or privilege <privilege> from <user-or-role-1> to <user-or-role-2> not found, revoke request ignored.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p>Where <privilege> is a Trafodion privilege and <user-or-role-1> and <user-or-role-2> are user IDs or roles.</p>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You attempted to revoke a privilege from <user-or-role-2> via <user-or-role-1>, but <user-or-role-1>
+did not grant that privilege to <user-or-role-2>. Note that <user-or-role-2> can be PUBLIC but <user-or-role-1>
+cannot.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> If <privilege> or <user-or-role-2> are incorrect, correct
+them and resubmit. If <user-or-role-1> is incorrect, reconnect to
+the Trafodion database via the correct user ID or role.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-1020">3.17. SQL 1020</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Privilege settings on metadata tables cannot be changed.</code></pre>
@@ -2113,9 +2149,10 @@ They cannot be changed.</p>
<div class="paragraph">
<p><strong>Recovery:</strong> None.</p>
</div>
+<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1021">3.16. SQL 1021</h3>
+<h3 id="SQL-1021">3.18. SQL 1021</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">SQL is already initialized on system <node-name>.</code></pre>
@@ -2135,10 +2172,9 @@ node.</p>
<div class="paragraph">
<p><strong>Recovery:</strong> None needed if SQL is operating normally.</p>
</div>
-<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1022">3.17. SQL 1022</h3>
+<h3 id="SQL-1022">3.19. SQL 1022</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Schema <schema-name> already exists.</code></pre>
@@ -2159,59 +2195,13 @@ contains a schema with that name.</p>
default generates the correct catalog name. Retry the request,
specifying a schema that does not already exist.</p>
</div>
-</div>
-<div class="sect2">
-<h3 id="SQL-1023">3.18. SQL 1023</h3>
-<div class="listingblock">
-<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">Only services ID can name an authorization ID other than the current user name.</code></pre>
-</div>
-</div>
-<div class="paragraph">
-<p><strong>Cause:</strong> You attempted to create a schema with the authorization ID of
-another user. Only the services ID can do this.</p>
-</div>
-<div class="paragraph">
-<p><strong>Effect:</strong> The operation fails.</p>
-</div>
-<div class="paragraph">
-<p><strong>Recovery:</strong> Use the services ID to create a schema with another owner.</p>
-</div>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1024">3.19. SQL 1024</h3>
-<div class="listingblock">
-<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">File system error <error-number> occurred on <text-string-1> <text-string-2>.</code></pre>
-</div>
-</div>
-<div class="paragraph">
-<p>Where <error-number> is an error originating from the file system.</p>
-</div>
-<div class="paragraph">
-<p>Where <text-string-1> is the file name.</p>
-</div>
-<div class="paragraph">
-<p>Where <text-string-2> is (optionally) additional details about the
-error.</p>
-</div>
-<div class="paragraph">
-<p><strong>Cause:</strong> Look up this error number in the file system manual to
-determine the cause.</p>
-</div>
-<div class="paragraph">
-<p><strong>Effect:</strong> The operation fails.</p>
-</div>
-<div class="paragraph">
-<p><strong>Recovery:</strong> For information about file system errors, see <a href="#file_system_errors">File-System Errors</a>.</p>
-</div>
-</div>
-<div class="sect2">
<h3 id="SQL-1025">3.20. SQL 1025</h3>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">Request failed. One or more dependent objects exist.</code></pre>
+<pre class="CodeRay highlight"><code data-lang="text">Request failed. Dependent object <object-name> exists.</code></pre>
</div>
</div>
<div class="paragraph">
@@ -2229,55 +2219,32 @@ you can reissue the statement specifying CASCADE. For other DROP
statements, you must first drop each of the dependent objects, then drop
the object.</p>
</div>
-<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1026">3.21. SQL 1026</h3>
+<h3 id="SQL-1027">3.21. SQL 1027</h3>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">Only the schema owner or services ID can drop a schema.</code></pre>
-</div>
+<pre class="CodeRay highlight"><code data-lang="text">The view <view-name> was created before column privileges were supported. To grant column privileges, please recreate the view.</code></pre>
</div>
-<div class="paragraph">
-<p><strong>Cause:</strong> An attempt was made to drop a schema by someone other than its
-owner or the services ID.</p>
</div>
<div class="paragraph">
-<p><strong>Effect:</strong> No SQL objects are dropped.</p>
-</div>
-<div class="paragraph">
-<p><strong>Recovery:</strong> The owner of the schema (or services ID) needs to issue the
-DROP SCHEMA statement.</p>
-</div>
-</div>
-<div class="sect2">
-<h3 id="SQL-1027">3.22. SQL 1027</h3>
-<div class="listingblock">
-<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">The definition schema <definition-schema-name> is dropped when its catalog is dropped.</code></pre>
-</div>
-</div>
-<div class="paragraph">
-<p>Where <definition-schema-name> is the name of the definition schema
+<p>Where <view-name> is the name of the view
specified.</p>
</div>
<div class="paragraph">
-<p><strong>Cause:</strong> You attempted to drop the schema containing the metadata tables
-for the catalog.</p>
+<p><strong>Cause:</strong> You attempted to grant column privileges on a view that was created
+on an earlier release of the Trafodion software, before column privileges were supported.</p>
</div>
<div class="paragraph">
-<p><strong>Effect:</strong> No SQL objects are dropped.</p>
+<p><strong>Effect:</strong> No column privileges were granted.</p>
</div>
<div class="paragraph">
-<p><strong>Recovery:</strong> Use DROP SCHEMA statements to drop all the user-created
-schemas in the catalog. Then use the DROP CATALOG statement to drop the
-catalog. The schema <definition-schema-name> is dropped when you drop
-its catalog.</p>
+<p><strong>Recovery:</strong> Drop and recreate the view, then resubmit the grant request.</p>
</div>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1028">3.23. SQL 1028</h3>
+<h3 id="SQL-1028">3.22. SQL 1028</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">The schema must be empty. It contains at least one object <object-name>.</code></pre>
@@ -2300,7 +2267,7 @@ the statement, or resubmit the drop statement using the CASCADE option.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1029">3.24. SQL 1029</h3>
+<h3 id="SQL-1029">3.23. SQL 1029</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Object <object-name> could not be created.</code></pre>
@@ -2322,30 +2289,32 @@ accompanying error messages to determine the cause.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1030">3.25. SQL 1030</h3>
+<h3 id="SQL-1030">3.24. SQL 1030</h3>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">File label <file-name> could not be accessed. File system error <error>.</code></pre>
+<pre class="CodeRay highlight"><code data-lang="text">The HBase name has a length of <actual-length> which is too long. Maximum length supported is <max-length>.</code></pre>
</div>
</div>
<div class="paragraph">
-<p>Where <file-name> is the name of a Trafodion database file.</p>
+<p>Where <actual-length> is the length of the generated HBase name.</p>
</div>
<div class="paragraph">
-<p>Where <error> is a file system error number.</p>
+<p>Where <max-length> is the maximum allowed HBase name length.</p>
</div>
<div class="paragraph">
-<p><strong>Cause:</strong> See the accompanying error message for the cause.</p>
+<p><strong>Cause:</strong> You attempted to create a Trafodion object which Trafodion stores in an HBase file.
+The generated HBase name (consisting of catalog name, schema name and object name, separated by periods)
+is too long for HBase.</p>
</div>
<div class="paragraph">
<p><strong>Effect:</strong> The operation fails.</p>
</div>
<div class="paragraph">
-<p><strong>Recovery:</strong> For information about file system errors, see <a href="#file_system_errors">File-System Errors</a>.</p>
+<p><strong>Recovery:</strong> Use a shorter name and resubmit.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1031">3.26. SQL 1031</h3>
+<h3 id="SQL-1031">3.25. SQL 1031</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Object <object-name> could not be dropped.</code></pre>
@@ -2366,104 +2335,134 @@ accompanying error messages to determine the cause.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1035">3.27. SQL 1035</h3>
+<h3 id="SQL-1032">3.26. SQL 1032</h3>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">Catalog <catalog-name> already exists.</code></pre>
+<pre class="CodeRay highlight"><code data-lang="text">The DISPLAY command completes and the query is not executed.</code></pre>
</div>
</div>
<div class="paragraph">
-<p>Where <catalog-name> is the name of a Trafodion database catalog.</p>
+<p><strong>Cause:</strong> You used the DISPLAY command to get insight into the
+plan generated for a particular query. When DISPLAY is used,
+the query is not executed.</p>
</div>
<div class="paragraph">
-<p><strong>Cause:</strong> You attempted to create a catalog using the name of an already
-existing catalog.</p>
+<p><strong>Effect:</strong> The query is not executed.</p>
</div>
<div class="paragraph">
-<p><strong>Effect:</strong> The operation fails.</p>
+<p><strong>Recovery:</strong> If you wish to execute the query, resubmit without
+the DISPLAY command.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-1034">3.27. SQL 1034</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Unable to obtain privileges.</code></pre>
+</div>
</div>
<div class="paragraph">
-<p><strong>Recovery:</strong> None if this is the desired catalog. Otherwise, correct the
-catalog name and resubmit.</p>
+<p><strong>Cause:</strong> You attempted a DDL or GRANT/REVOKE operation but Trafodion
+could not retrieve privilege information needed to process the request.
+Additional error messages may give insight to the cause.</p>
</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation is not executed.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> None. Contact the Trafodion Developer Distribution List.</p>
+</div>
+<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1036">3.28. SQL 1036</h3>
+<h3 id="SQL-1035">3.28. SQL 1035</h3>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">Only super ID can execute DROP SQL.</code></pre>
+<pre class="CodeRay highlight"><code data-lang="text">Catalog <catalog-name> already exists.</code></pre>
+</div>
</div>
+<div class="paragraph">
+<p>Where <catalog-name> is the name of a Trafodion database catalog.</p>
</div>
<div class="paragraph">
-<p><strong>Cause:</strong> An attempt was made to drop SQL by a user who is not the super
-ID.</p>
+<p><strong>Cause:</strong> You attempted to create a catalog using the name of an already
+existing catalog.</p>
</div>
<div class="paragraph">
<p><strong>Effect:</strong> The operation fails.</p>
</div>
<div class="paragraph">
-<p><strong>Recovery:</strong> The super ID needs to issue the DROP SCHEMA statement.</p>
+<p><strong>Recovery:</strong> None if this is the desired catalog. Otherwise, correct the
+catalog name and resubmit.</p>
</div>
-<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1037">3.29. SQL 1037</h3>
+<h3 id="SQL-1036">3.29. SQL 1036</h3>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">{project-name} is not installed on system <node>.</code></pre>
+<pre class="CodeRay highlight"><code data-lang="text">Authorization ID <auth-id-1> cannot grant to authorization ID <auth-id-2> because it could create a circular dependency.</code></pre>
</div>
</div>
<div class="paragraph">
-<p>Where <node> is the name of the node referenced by the operation.</p>
+<p>Where <auth-id-1> is the authorization ID performing the GRANT.</p>
</div>
<div class="paragraph">
-<p><strong>Cause:</strong> In a replication or distribution context: An operation
-attempted to create a catalog reference or a partition on a node where
-the Trafodion database has not been installed.</p>
+<p>Where <auth-id-2> is the authorization ID that is the target of the GRANT.</p>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> There is a chain of grants leading from <auth-id-2> back to <auth-id-1>. Granting
+this request might create a circular dependency.</p>
</div>
<div class="paragraph">
<p><strong>Effect:</strong> The operation fails.</p>
</div>
<div class="paragraph">
-<p><strong>Recovery:</strong> Either reissue the statement specifying a different node, or
-install the Trafodion database on <node> and resubmit.</p>
+<p><strong>Recovery:</strong> None.</p>
</div>
+<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1038">3.30. SQL 1038</h3>
+<h3 id="SQL-1037">3.30. SQL 1037</h3>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">Not all user catalogs have been dropped from the system.</code></pre>
+<pre class="CodeRay highlight"><code data-lang="text">Revoke failed because of a dependent grant between authorization ID <auth-id-1> and authorization ID <auth-id-2>.</code></pre>
+</div>
</div>
+<div class="paragraph">
+<p>Where <auth-id-1> and <auth-id-2> are authorization IDs.</p>
</div>
<div class="paragraph">
-<p><strong>Cause:</strong> You attempted to drop SQL while one or more user-created
-catalogs existed.</p>
+<p><strong>Cause:</strong> You attempted to revoke a privilege from <auth-id-1>, but
+that user or role has granted that privilege to a third authorization ID.</p>
</div>
<div class="paragraph">
<p><strong>Effect:</strong> The operation fails.</p>
</div>
<div class="paragraph">
-<p><strong>Recovery:</strong> You must drop all user-created catalogs before dropping SQL.</p>
+<p><strong>Recovery:</strong> Reconnect to the Trafodion database using an authorization ID
+that can revoke the dependent privileges, then reconnect again under the
+original authorization ID and resubmit.</p>
</div>
-<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
<h3 id="SQL-1039">3.31. SQL 1039</h3>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">The DROP SQL statement could not be executed.</code></pre>
+<pre class="CodeRay highlight"><code data-lang="text">No privileges were revoked. You lack the grant option for the specified privilege(s).</code></pre>
</div>
</div>
<div class="paragraph">
-<p><strong>Cause:</strong> See the accompanying error message for the cause.</p>
+<p><strong>Cause:</strong> You attempted to revoke privileges from an authorization ID, but you do not
+have the ability (grant option) to perform this operation.</p>
</div>
<div class="paragraph">
-<p><strong>Effect:</strong> Trafodion does not drop SQL.</p>
+<p><strong>Effect:</strong> The operation fails.</p>
</div>
<div class="paragraph">
-<p><strong>Recovery:</strong> Apply the recovery of the accompanying error message.</p>
+<p><strong>Recovery:</strong> Reconnect to the Trafodion database using an authorization ID
+that has grant option for these privileges and resubmit.</p>
</div>
+<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
<h3 id="SQL-1040">3.32. SQL 1040</h3>
@@ -2482,7 +2481,6 @@ of the Trafodion database metadata. Such tables cannot be altered.</p>
<div class="paragraph">
<p><strong>Recovery:</strong> None.</p>
</div>
-<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
<h3 id="SQL-1041">3.33. SQL 1041</h3>
@@ -2642,7 +2640,7 @@ on the DROP statement for the object.</p>
<h3 id="SQL-1048">3.40. SQL 1048</h3>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">The statement currently supports only RESTRICT drop behavior.</code></pre>
+<pre class="CodeRay highlight"><code data-lang="text">The statement currently supports only RESTRICT behavior.</code></pre>
</div>
</div>
<div class="paragraph">
@@ -2719,7 +2717,27 @@ security needed to create a view or trigger.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1053">3.44. SQL 1053</h3>
+<h3 id="SQL-1052">3.44. SQL 1052</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Constraint cannot be dropped because it does not belong to the specified table.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified ALTER TABLE DROP CONSTRAINT to drop a constraint from a given table.
+The constraint you specified, however, does not belong to the table you specified.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> To learn if the constraint name is incorrect, use SHOWDDL on the
+table you specified. Correct the name and resubmit.</p>
+</div>
+<div style="page-break-after: always;"></div>
+</div>
+<div class="sect2">
+<h3 id="SQL-1053">3.45. SQL 1053</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Unique index <index-name> could not be created because the specified column(s) contain duplicate data.</code></pre>
@@ -2740,56 +2758,55 @@ constraint specified in the CREATE INDEX statement.</p>
change the rows in the table to remove duplicates. Then reissue the
statement.</p>
</div>
-<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1057">3.45. SQL 1057</h3>
+<h3 id="SQL-1055">3.46. SQL 1055</h3>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">{project-name} objects cannot be created on <volume-name>: File system error <error-number>.</code></pre>
-</div>
+<pre class="CodeRay highlight"><code data-lang="text">Object <component-name> already exists.</code></pre>
</div>
-<div class="paragraph">
-<p>Where <volume-name> is the name of a volume.</p>
</div>
<div class="paragraph">
-<p>Where <error-number> is the file system error number.</p>
+<p>Where <component-name> is a component name you specified on a REGISTER COMPONENT statement.</p>
</div>
<div class="paragraph">
-<p><strong>Cause:</strong> An attempt to create a file on volume <volume-name> resulted in
-file system error <error-number>.</p>
+<p><strong>Cause:</strong> You attempted to register a new component in the
+Trafodion database but this component already exists.</p>
</div>
<div class="paragraph">
-<p><strong>Effect:</strong> The operation fails.</p>
+<p><strong>Effect:</strong> The operation takes no action.</p>
</div>
<div class="paragraph">
-<p><strong>Recovery:</strong> For information about file system errors, see <a href="#file_system_errors">File-System Errors</a>.</p>
+<p><strong>Recovery:</strong> If the component name is incorrect, correct and resubmit.</p>
</div>
+<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1058">3.46. SQL 1058</h3>
+<h3 id="SQL-1058">3.47. SQL 1058</h3>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">Lock <lock-name> already exists.</code></pre>
+<pre class="CodeRay highlight"><code data-lang="text">Unable to create histogram table <table-name>.</code></pre>
</div>
</div>
<div class="paragraph">
-<p>Where <lock-name> is the name of the DDL lock.</p>
+<p>Where <table-name> is the name of the histogram table that could not be created.</p>
</div>
<div class="paragraph">
-<p><strong>Cause:</strong> The statement required creation of a lock with a unique lock
-name, which was not generated.</p>
+<p><strong>Cause:</strong> You attempted to execute a CREATE SCHEMA statement, but one
+of the histogram tables needed for the schema could not be created.
+Additional error messages may give insight to the cause.</p>
</div>
<div class="paragraph">
<p><strong>Effect:</strong> The operation fails.</p>
</div>
<div class="paragraph">
-<p><strong>Recovery:</strong> Specify a unique lock name and resubmit.</p>
+<p><strong>Recovery:</strong> None. Contact the Trafodion Developer Distribution List.
+Supply the name of the table that could not be created and any accompanying
+error messages.</p>
</div>
-<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1059">3.47. SQL 1059</h3>
+<h3 id="SQL-1059">3.48. SQL 1059</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Request failed. Dependent constraint <constraint-name> exists.</code></pre>
@@ -2811,42 +2828,21 @@ or a check constraint that refers to another table.</p>
then drop the table, or reissue the DROP TABLE statement, specifying the
CASCADE option.</p>
</div>
-</div>
-<div class="sect2">
-<h3 id="SQL-1061">3.48. SQL 1061</h3>
-<div class="listingblock">
-<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">Dropping metadata catalog <catalog-name> is not allowed.</code></pre>
-</div>
-</div>
-<div class="paragraph">
-<p>Where <catalog-name> is the name of a Trafodion database catalog.</p>
-</div>
-<div class="paragraph">
-<p><strong>Cause:</strong> You attempted to drop a catalog that is part of the Trafodion
-database metadata.</p>
-</div>
-<div class="paragraph">
-<p><strong>Effect:</strong> The operation fails.</p>
-</div>
-<div class="paragraph">
-<p><strong>Recovery:</strong> None.</p>
-</div>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
<h3 id="SQL-1062">3.49. SQL 1062</h3>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">Dropping metadata schema <schema-name> is not allowed.</code></pre>
+<pre class="CodeRay highlight"><code data-lang="text">Dropping metadata or reserved schema <schema-name> is not allowed.</code></pre>
</div>
</div>
<div class="paragraph">
-<p>Where <schema-name> is the name of a Trafodion database metadata schema.</p>
+<p>Where <schema-name> is the name of a Trafodion database metadata or reserved schema.</p>
</div>
<div class="paragraph">
<p><strong>Cause:</strong> You attempted to drop a schema that is part of the Trafodion
-database metadata.</p>
+database metadata or is reserved.</p>
</div>
<div class="paragraph">
<p><strong>Effect:</strong> The operation fails.</p>
@@ -2856,117 +2852,53 @@ database metadata.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1063">3.50. SQL 1063</h3>
+<h3 id="SQL-1068">3.50. SQL 1068</h3>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">Dropping metadata index <index-name> is not allowed.</code></pre>
-</div>
+<pre class="CodeRay highlight"><code data-lang="text">Initialize authorization completed with warnings.</code></pre>
</div>
-<div class="paragraph">
-<p>Where <index-name> is the name of a Trafodion database index.</p>
</div>
<div class="paragraph">
-<p><strong>Cause:</strong> An attempt was made to drop an index that is part of the
-Trafodion database metadata.</p>
+<p><strong>Cause:</strong> You attempted to initialize authorization in the Trafodion database.
+This succeeded, however some warnings were reported. This message is
+accompanied by additional warning messages which report the specifics.</p>
</div>
<div class="paragraph">
-<p><strong>Effect:</strong> The operation fails.</p>
+<p><strong>Effect:</strong> The operation succeeds, however there may be issues you wish to address.</p>
</div>
<div class="paragraph">
-<p><strong>Recovery:</strong> None.</p>
+<p><strong>Recovery:</strong> Consult the descriptions of the accompanying warning messages.</p>
</div>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1064">3.51. SQL 1064</h3>
+<h3 id="SQL-1069">3.51. SQL 1069</h3>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">Dropping metadata view <table-name> is not allowed.</code></pre>
-</div>
-</div>
-<div class="paragraph">
-<p>Where <table-name> is the name of a Trafodion database table.</p>
-</div>
-<div class="paragraph">
-<p><strong>Cause:</strong> An attempt was made to drop a view that is a metadata object.
-Metadata views and their creation are not currently supported, so this
-error should not be encountered.</p>
-</div>
-<div class="paragraph">
-<p><strong>Effect:</strong> The operation fails.</p>
-</div>
-<div class="paragraph">
-<p><strong>Recovery:</strong> None.</p>
+<pre class="CodeRay highlight"><code data-lang="text">Schema <schema-name> could not be dropped. <details></code></pre>
</div>
</div>
-<div class="sect2">
-<h3 id="SQL-1065">3.52. SQL 1065</h3>
-<div class="listingblock">
-<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">Creating constraint <constraint-name> in metadata schema is not allowed.</code></pre>
-</div>
-</div>
-<div class="paragraph">
-<p>Where <constraint-name> is the name of the constraint.</p>
-</div>
-<div class="paragraph">
-<p><strong>Cause:</strong> You attempted to create a constraint on a metadata table, which
-is not allowed.</p>
-</div>
-<div class="paragraph">
-<p><strong>Effect:</strong> The operation fails.</p>
-</div>
<div class="paragraph">
-<p><strong>Recovery:</strong> None.</p>
-</div>
-<div style="page-break-after: always;"></div>
-</div>
-<div class="sect2">
-<h3 id="SQL-1066">3.53. SQL 1066</h3>
-<div class="listingblock">
-<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">Creating index <index-name> in metadata schema is not allowed.</code></pre>
-</div>
-</div>
-<div class="paragraph">
-<p>Where <index-name> is the name specified for the index.</p>
-</div>
-<div class="paragraph">
-<p><strong>Cause:</strong> You attempted to create an index on a metadata table, which is
-not allowed.</p>
-</div>
-<div class="paragraph">
-<p><strong>Effect:</strong> The operation fails.</p>
-</div>
-<div class="paragraph">
-<p><strong>Recovery:</strong> None.</p>
-</div>
-</div>
-<div class="sect2">
-<h3 id="SQL-1069">3.54. SQL 1069</h3>
-<div class="listingblock">
-<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">Schema <schema-name> could not be dropped.</code></pre>
-</div>
+<p>Where <schema-name> is the name of a Trafodion database schema.</p>
</div>
<div class="paragraph">
-<p>Where <schema-name> is the name of a Trafodion database schema.</p>
+<p>Where <details> is additional message text giving details concerning
+why the schema could not be dropped.</p>
</div>
<div class="paragraph">
-<p><strong>Cause:</strong> See the accompanying error message for the cause of the
-problem.</p>
+<p><strong>Cause:</strong> The cause is given in the <details>.</p>
</div>
<div class="paragraph">
<p><strong>Effect:</strong> The operation fails.</p>
</div>
<div class="paragraph">
-<p><strong>Recovery:</strong> Apply the recovery action from the accompanying error
-message.</p>
+<p><strong>Recovery:</strong> The <details> may offer insights. Possibly there is an
+inconsistency between HBase and the Trafodion metadata. The
+CLEANUP SCHEMA command may be used to recover in these cases.</p>
</div>
-<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1070">3.55. SQL 1070</h3>
+<h3 id="SQL-1070">3.52. SQL 1070</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Object <object-name> could not be created. File error: <error-number>.</code></pre>
@@ -2988,148 +2920,38 @@ system error <error-number>.</p>
<div class="paragraph">
<p><strong>Recovery:</strong> For information about file system errors, see <a href="#file_system_errors">File-System Errors</a>.</p>
</div>
-</div>
-<div class="sect2">
-<h3 id="SQL-1071">3.56. SQL 1071</h3>
-<div class="listingblock">
-<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">Object <ANSI-name> could not be accessed.</code></pre>
-</div>
-</div>
-<div class="paragraph">
-<p>Where <ANSI-name> is the name of the Trafodion database object.</p>
-</div>
-<div class="paragraph">
-<p><strong>Cause:</strong> The statement issued required access to the Trafodion platform
-file underlying object <ANSI-name>.</p>
-</div>
-<div class="paragraph">
-<p><strong>Effect:</strong> The operation fails.</p>
-</div>
-<div class="paragraph">
-<p><strong>Recovery:</strong> Apply the recovery action from the accompanying error
-message.</p>
-</div>
-<div style="page-break-after: always;"></div>
-</div>
-<div class="sect2">
-<h3 id="SQL-1072">3.57. SQL 1072</h3>
-<div class="listingblock">
-<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">Unique constraint <constraint-name-1> is disabled, so foreign key constraint <constraint-name-2> could not be created.</code></pre>
-</div>
-</div>
-<div class="paragraph">
-<p>Where <constraint-name-1> is the name of the disabled constraint.</p>
-</div>
-<div class="paragraph">
-<p>Where <constraint-name-2> is the name of the foreign key constraint.</p>
-</div>
-<div class="paragraph">
-<p><strong>Cause:</strong> You created a referential constraint that references a unique
-constraint that has been disabled. This is an internal error.</p>
-</div>
-<div class="paragraph">
-<p><strong>Effect:</strong> The operation fails.</p>
-</div>
-<div class="paragraph">
-<p><strong>Recovery:</strong> Create the referential constraint that references a unique
-constraint that has not been disabled.</p>
-</div>
-</div>
-<div class="sect2">
-<h3 id="SQL-1073">3.58. SQL 1073</h3>
-<div class="listingblock">
-<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">Only services ID can execute INITIALIZE SQL.</code></pre>
-</div>
-</div>
-<div class="paragraph">
-<p><strong>Cause:</strong> You attempted to initialize the Trafodion database, but you are
-not the services ID. Only the services ID can perform this function.</p>
-</div>
-<div class="paragraph">
-<p><strong>Effect:</strong> The operation fails.</p>
-</div>
-<div class="paragraph">
-<p><strong>Recovery:</strong> Log on as the services ID before executing this command.</p>
-</div>
-<div style="page-break-after: always;"></div>
-</div>
-<div class="sect2">
-<h3 id="SQL-1075">3.59. SQL 1075</h3>
-<div class="listingblock">
-<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">The catalog must be empty. It contains at least one schema <schema-name>.</code></pre>
-</div>
-</div>
-<div class="paragraph">
-<p>Where <schema-name> is the name of a schema in the specified catalog.</p>
-</div>
-<div class="paragraph">
-<p><strong>Cause:</strong> An attempt was made to drop a catalog that is not empty.</p>
-</div>
-<div class="paragraph">
-<p><strong>Effect:</strong> The catalog is not dropped. None of its schemas are dropped.</p>
-</div>
-<div class="paragraph">
-<p><strong>Recovery:</strong> Drop all schemas in the catalog and resubmit.</p>
-</div>
-<div class="paragraph">
-<p><strong>Recovery:</strong> None. Contact the Trafodion User Distribution List</p>
-</div>
-</div>
-<div class="sect2">
-<h3 id="SQL-1078">3.60. SQL 1078</h3>
-<div class="listingblock">
-<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">The format of the specified location name <location-name> is not valid.</code></pre>
-</div>
-</div>
-<div class="paragraph">
-<p>Where <location-name> is a name specified in a LOCATION clause.</p>
-</div>
-<div class="paragraph">
-<p><strong>Cause:</strong> An invalid name was supplied in a LOCATION clause.</p>
-</div>
-<div class="paragraph">
-<p><strong>Effect:</strong> The operation fails.</p>
-</div>
-<div class="paragraph">
-<p><strong>Recovery:</strong> See the <a href="http://trafodion.incubator.apache.org/docs/sql_reference/index.html"><em>Trafodion SQL Reference Manual</em></a> for limitations on
-names allowed in the LOCATION clause. Correct the name and resubmit.</p>
-</div>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1079">3.61. SQL 1079</h3>
+<h3 id="SQL-1073">3.53. SQL 1073</h3>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">{project-name} was not able to prepare the statement.</code></pre>
+<pre class="CodeRay highlight"><code data-lang="text">Schema <schema-name> was partially dropped. Use CLEANUP SCHEMA to remove remaining entries.</code></pre>
</div>
</div>
<div class="paragraph">
-<p><strong>Cause:</strong> See the accompanying error message for the cause.</p>
+<p><strong>Cause:</strong> You attempted to drop the specified schema, however Trafodion
+was only able to partially drop it.</p>
</div>
<div class="paragraph">
<p><strong>Effect:</strong> The operation fails.</p>
</div>
<div class="paragraph">
-<p><strong>Recovery:</strong> Apply the recovery of the accompanying error message.</p>
+<p><strong>Recovery:</strong> Use the CLEANUP SCHEMA <schema-name> command to drop anything remaining.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1080">3.62. SQL 1080</h3>
+<h3 id="SQL-1080">3.54. SQL 1080</h3>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">The create request has duplicate references to column <column-name>.</code></pre>
+<pre class="CodeRay highlight"><code data-lang="text">The DDL request has duplicate references to column <column-name>.</code></pre>
</div>
</div>
<div class="paragraph">
<p>Where <column-name> is the name of a column of a table.</p>
</div>
<div class="paragraph">
-<p><strong>Cause:</strong> You attempted to create a table that has two columns with the
+<p><strong>Cause:</strong> You attempted to create a table or view that has two columns with the
same name. If you name a column "SYSKEY," duplication can result from
the implicit creation by the Trafodion database software of a column
named SYSKEY to ensure uniqueness for the clustering key.</p>
@@ -3143,7 +2965,7 @@ named SYSKEY to ensure uniqueness for the clustering key.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1081">3.63. SQL 1081</h3>
+<h3 id="SQL-1081">3.55. SQL 1081</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Loading of index <index-name> failed unexpectedly.</code></pre>
@@ -3166,7 +2988,7 @@ data could not be loaded into the index by the Call-level interface
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1082">3.64. SQL 1082</h3>
+<h3 id="SQL-1082">3.56. SQL 1082</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Validation for constraint <constraint-name> failed unexpectedly.</code></pre>
@@ -3192,7 +3014,7 @@ constraint, remove that data and resubmit.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1083">3.65. SQL 1083</h3>
+<h3 id="SQL-1083">3.57. SQL 1083</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Validation for constraint <constraint-name> failed; incompatible data exists in table.</code></pre>
@@ -3213,7 +3035,7 @@ resubmit.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1084">3.66. SQL 1084</h3>
+<h3 id="SQL-1084">3.58. SQL 1084</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">An invalid default value was specified for column <column-name>.</code></pre>
@@ -3235,86 +3057,7 @@ for <column-name>.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1085">3.67. SQL 1085</h3>
-<div class="listingblock">
-<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">The calculated key length is greater than 255 bytes.</code></pre>
-</div>
-</div>
-<div class="paragraph">
-<p><strong>Cause:</strong> The length of the primary key, which is calculated by the
-number of primary key columns and their data types, exceeds the maximum
-length.</p>
-</div>
-<div class="paragraph">
-<p><strong>Effect:</strong> The operation fails.</p>
-</div>
-<div class="paragraph">
-<p><strong>Recovery:</strong> Make sure the key length is less than 255 bytes and
-resubmit.</p>
-</div>
-</div>
-<div class="sect2">
-<h3 id="SQL-1086">3.68. SQL 1086</h3>
-<div class="listingblock">
-<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">Lock <lock-name> does not exist.</code></pre>
-</div>
-</div>
-<div class="paragraph">
-<p>Where <lock-name> is the name of the specified lock.</p>
-</div>
-<div class="paragraph">
-<p><strong>Cause:</strong> Lock <lock-name> was specified, but does not exist.</p>
-</div>
-<div class="paragraph">
-<p><strong>Effect:</strong> The operation fails.</p>
-</div>
-<div class="paragraph">
-<p><strong>Recovery:</strong> Create a lock <lock-name> or specify a valid lock name and
-resubmit.</p>
-</div>
-<div style="page-break-after: always;"></div>
-</div>
-<div class="sect2">
-<h3 id="SQL-1087">3.69. SQL 1087</h3>
-<div class="listingblock">
-<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">DDL lock cannot be granted, invalid operation has been specified.</code></pre>
-</div>
-</div>
-<div class="paragraph">
-<p><strong>Cause:</strong> An invalid utility operation requested a DDL lock.</p>
-</div>
-<div class="paragraph">
-<p><strong>Effect:</strong> The lock request fails.</p>
-</div>
-<div class="paragraph">
-<p><strong>Recovery:</strong> Specify a valid utility operation, or check to see if
-invalid utilities are being run, and resubmit.</p>
-</div>
-</div>
-<div class="sect2">
-<h3 id="SQL-1088">3.70. SQL 1088</h3>
-<div class="listingblock">
-<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">The system generated column SYSKEY must be specified last or not specified at all in the STORE BY column list.</code></pre>
-</div>
-</div>
-<div class="paragraph">
-<p><strong>Cause:</strong> If the system-generated column SKSKEY is specified in the STORE
-BY list of columns, it must be specified last.</p>
-</div>
-<div class="paragraph">
-<p><strong>Effect:</strong> The operation fails.</p>
-</div>
-<div class="paragraph">
-<p><strong>Recovery:</strong> Correct the STORE BY clause and resubmit.</p>
-</div>
-<div style="page-break-after: always;"></div>
-</div>
-<div class="sect2">
-<h3 id="SQL-1089">3.71. SQL 1089</h3>
+<h3 id="SQL-1089">3.59. SQL 1089</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">The system generated column SYSKEY must be specified last or not specified at all in the index column list.</code></pre>
@@ -3333,7 +3076,7 @@ list and resubmit the statement.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1090">3.72. SQL 1090</h3>
+<h3 id="SQL-1090">3.60. SQL 1090</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Self-referencing constraints are currently not supported.</code></pre>
@@ -3353,72 +3096,17 @@ referencing the primary key of the same table.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1094">3.73. SQL 1094</h3>
-<div class="listingblock">
-<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">Object <object-name> could not be dropped because it is not of type <object-type>.</code></pre>
-</div>
-</div>
-<div class="paragraph">
-<p>Where <object-name> is the ANSI name of the object stated in the DROP
-command.</p>
-</div>
-<div class="paragraph">
-<p>Where <object-type> is the type of object that was stated in the DROP
-command.</p>
-</div>
-<div class="paragraph">
-<p><strong>Cause:</strong> A DROP TABLE specified an object that is not a base table, or a
-DROP VIEW specified an object that is not a view, or a DROP PROCEDURE
-specified an object that is not a procedure.</p>
-</div>
-<div class="paragraph">
-<p><strong>Effect:</strong> The operation fails.</p>
-</div>
-<div class="paragraph">
-<p><strong>Recovery:</strong> Reissue the DROP statement with the correct combination of
-specified object type and actual object type.</p>
-</div>
-</div>
-<div class="sect2">
-<h3 id="SQL-1095">3.74. SQL 1095</h3>
-<div class="listingblock">
-<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">The PARTITION BY column <column-name> should also be part of the clustering/storage key.</code></pre>
-</div>
-</div>
-<div class="paragraph">
-<p>Where <column-name> is the name of a column of the specified table.</p>
-</div>
-<div class="paragraph">
-<p><strong>Cause:</strong> This error is reported if a column specified in the
-partitioning key of the <span class="menuseq"><span class="menu">PARTITION BY (<partitioning-columns</span> ▸ <span class="menuitem">)</span></span> clause
-of a CREATE TABLE or CREATE INDEX statement is not also a member of the
-clustering key.</p>
-</div>
-<div class="paragraph">
-<p><strong>Effect:</strong> The table or index is not created.</p>
-</div>
-<div class="paragraph">
-<p><strong>Recovery:</strong> Either remove the offending column from the partitioning key
-specification (and possibly replace it with a column that is a member of
-the clustering key) or add the offending column to the clustering key by
-using the STORE BY clause or by adding it to the primary key.</p>
-</div>
-<div style="page-break-after: always;"></div>
-</div>
-<div class="sect2">
-<h3 id="SQL-1098">3.75. SQL 1098</h3>
+<h3 id="SQL-1098">3.61. SQL 1098</h3>
<div class="listingblock">
<div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">Duplicate partition key (<key>)specified for object <object-name>.</code></pre>
+<pre class="CodeRay highlight"><code data-lang="text">Partition key (<key>) already specified for object <table-name>.</code></pre>
</div>
</div>
<div class="paragraph">
<p>Where <key> is a partition key.</p>
</div>
<div class="paragraph">
-<p>Where <object-name> is the name of the table being created or changed.</p>
+<p>Where <table-name> is the name of the table being created or changed.</p>
</div>
<div class="paragraph">
<p><strong>Cause:</strong> You attempted to create or change a table so that more than one
@@ -3433,7 +3121,7 @@ partitions to have the same first key, and resubmit.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1099">3.76. SQL 1099</h3>
+<h3 id="SQL-1099">3.62. SQL 1099</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Column <column-number> is unnamed. You must specify an AS clause for that column expression, or name all the columns by specifying a view column list.</code></pre>
@@ -3456,7 +3144,7 @@ unnamed column and resubmit.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1104">3.77. SQL 1104</h3>
+<h3 id="SQL-1104">3.63. SQL 1104</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Default value string is too long for column <column-name>.</code></pre>
@@ -3478,7 +3166,7 @@ the maximum of 239 characters.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1105">3.78. SQL 1105</h3>
+<h3 id="SQL-1105">3.64. SQL 1105</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">CREATE TABLE LIKE statement cannot contain both HORIZONTAL PARTITIONS and STORE BY clauses.</code></pre>
@@ -3497,7 +3185,7 @@ PARTITIONS and STORE BY clause, which is not allowed.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1106">3.79. SQL 1106</h3>
+<h3 id="SQL-1106">3.65. SQL 1106</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">The specified partition <partition-location> of object <table-name> does not exist.</code></pre>
@@ -3521,7 +3209,7 @@ partition operation does not exist.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1108">3.80. SQL 1108</h3>
+<h3 id="SQL-1108">3.66. SQL 1108</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">The number of columns specified in the view column list, <view-col-num>, does not match the degree of the query expression, <query-col-num>.</code></pre>
@@ -3548,7 +3236,7 @@ number of columns in the view column list, and resubmit.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1109">3.81. SQL 1109</h3>
+<h3 id="SQL-1109">3.67. SQL 1109</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">The WITH CHECK OPTION clause appears in the definition of view <view-name>, but the view is not updatable.</code></pre>
@@ -3570,7 +3258,7 @@ and resubmit.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1112">3.82. SQL 1112</h3>
+<h3 id="SQL-1112">3.68. SQL 1112</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">An index column list cannot consist only of the system-generated column SYSKEY.</code></pre>
@@ -3590,7 +3278,7 @@ reissue the statement.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1114">3.83. SQL 1114</h3>
+<h3 id="SQL-1114">3.69. SQL 1114</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Metadata tables for catalog <catalog-name> could not be created on <location-info>.</code></pre>
@@ -3616,7 +3304,7 @@ the cause.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1115">3.84. SQL 1115</h3>
+<h3 id="SQL-1115">3.70. SQL 1115</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Label <file-name> could not be created for <ANSI-name> (file error <error>).</code></pre>
@@ -3646,7 +3334,7 @@ statement. For information about file system errors, see <a href="#file_system_e
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1116">3.85. SQL 1116</h3>
+<h3 id="SQL-1116">3.71. SQL 1116</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">The current partitioning scheme requires a user-specified clustering key on object <table-name>.</code></pre>
@@ -3668,7 +3356,7 @@ STORE BY, or PARTITION BY clause.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1117">3.86. SQL 1117</h3>
+<h3 id="SQL-1117">3.72. SQL 1117</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Dropping the only partition of an object is not allowed. At least two partitions must exist to perform the drop.</code></pre>
@@ -3686,7 +3374,7 @@ STORE BY, or PARTITION BY clause.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1118">3.87. SQL 1118</h3>
+<h3 id="SQL-1118">3.73. SQL 1118</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Creating object <table-name> is not allowed in metadata schema.</code></pre>
@@ -3706,7 +3394,7 @@ STORE BY, or PARTITION BY clause.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1119">3.88. SQL 1119</h3>
+<h3 id="SQL-1119">3.74. SQL 1119</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Dropping metadata object <table-name> is not allowed.</code></pre>
@@ -3730,7 +3418,7 @@ destroy the database.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1120">3.89. SQL 1120</h3>
+<h3 id="SQL-1120">3.75. SQL 1120</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Use of float datatype in a partitioning key is not allowed.</code></pre>
@@ -3750,7 +3438,7 @@ statement and retry the operation.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1121">3.90. SQL 1121</h3>
+<h3 id="SQL-1121">3.76. SQL 1121</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Partitions cannot be added or dropped on table <table-name>. These partition operations are not allowed on tables whose clustering key consists only of the SYSKEY.</code></pre>
@@ -3772,7 +3460,7 @@ partition.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1122">3.91. SQL 1122</h3>
+<h3 id="SQL-1122">3.77. SQL 1122</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">The number of specified partition key values (<partitionkey-value-list>) for object <object-name> exceeds the number of user defined key columns, <key-col-number>.</code></pre>
@@ -3800,7 +3488,7 @@ number of user-defined key columns, <key-col-number>.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1123">3.92. SQL 1123</h3>
+<h3 id="SQL-1123">3.78. SQL 1123</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Not all of the partition key values (<key>) for object <object-name> could be processed. Please verify that the correct key value data types were specified.</code></pre>
@@ -3825,7 +3513,7 @@ contains an element that is not supported.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1124">3.93. SQL 1124</h3>
+<h3 id="SQL-1124">3.79. SQL 1124</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Use of a float datatype in a partitioning key has been enabled by the default ALLOW_FLOAT_DATATYPES_IN_PARTIONING_KEY. This could give some incorrect results and the users should be aware of it.</code></pre>
@@ -3847,7 +3535,7 @@ partitionable table.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1127">3.94. SQL 1127</h3>
+<h3 id="SQL-1127">3.80. SQL 1127</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">The specified table <table-name> is not a base table. Please verify that the correct table was specified.</code></pre>
@@ -3869,7 +3557,7 @@ only on a base table, and the specified object is not a base table.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1130">3.95. SQL 1130</h3>
+<h3 id="SQL-1130">3.81. SQL 1130</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">The column requires a default value.</code></pre>
@@ -3887,7 +3575,7 @@ without specifying a default value.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1132">3.96. SQL 1132</h3>
+<h3 id="SQL-1132">3.82. SQL 1132</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">An added column cannot have both DEFAULT NULL and NOT NULL.</code></pre>
@@ -3907,7 +3595,7 @@ NULL and resubmit.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1133">3.97. SQL 1133</h3>
+<h3 id="SQL-1133">3.83. SQL 1133</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Only super ID can perform this operation.</code></pre>
@@ -3925,7 +3613,7 @@ only by the super ID.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1134">3.98. SQL 1134</h3>
+<h3 id="SQL-1134">3.84. SQL 1134</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">A concurrent utility or DDL is being performed on object <object-name>, its parent, or one of its dependencies. That operation must complete before the requested operation can run.</code></pre>
@@ -3949,7 +3637,7 @@ resubmit.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1135">3.99. SQL 1135</h3>
+<h3 id="SQL-1135">3.85. SQL 1135</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Clustering key column <column-name> must be assigned a NOT NULL NOT DROPPABLE constraint.</code></pre>
@@ -3971,7 +3659,7 @@ resubmit.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1136">3.100. SQL 1136</h3>
+<h3 id="SQL-1136">3.86. SQL 1136</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">For an added column, the PRIMARY KEY clause cannot specify NOT DROPPABLE.</code></pre>
@@ -3992,7 +3680,7 @@ the primary key.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1139">3.101. SQL 1139</h3>
+<h3 id="SQL-1139">3.87. SQL 1139</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">System-generated column <column-name> of base table <table-name> cannot appear in the search condition of a check constraint definition.</code></pre>
@@ -4018,7 +3706,7 @@ any system-generated column and resubmit.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1140">3.102. SQL 1140</h3>
+<h3 id="SQL-1140">3.88. SQL 1140</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Row-length <actual-row-length> exceeds the maximum allowed row-length of <maximum-row-length> for table <table-name>.</code></pre>
@@ -4047,7 +3735,7 @@ calculations. Change the column definitions and reissue the statement.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1141">3.103. SQL 1141</h3>
+<h3 id="SQL-1141">3.89. SQL 1141</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Label <file-name> for object could not be accessed. File system error <error-number>.</code></pre>
@@ -4072,7 +3760,7 @@ system error.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1142">3.104. SQL 1142</h3>
+<h3 id="SQL-1142">3.90. SQL 1142</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Because it is not audited, this table cannot have a column added that is declared NOT NULL, or has a CHECK, UNIQUE, PRIMARY KEY, or FOREIGN KEY constraint.</code></pre>
@@ -4091,7 +3779,7 @@ operation.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1143">3.105. SQL 1143</h3>
+<h3 id="SQL-1143">3.91. SQL 1143</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Validation for constraint <constraint-name> failed; incompatible data exists in referencing base table <referencing-table-name> and referenced base table <referenced-table-name>. To display the data violating the constraint, please use the following DML statement: <statement-text>.</code></pre>
@@ -4126,7 +3814,7 @@ referential constraint definition and resubmit.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1144">3.106. SQL 1144</h3>
+<h3 id="SQL-1144">3.92. SQL 1144</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">A quoted string was expected in first key clause for column <column-name> on table <table-name>, but the value detected is (<first-key-string>).</code></pre>
@@ -4157,7 +3845,7 @@ compatible with the type of column <column-name> and resubmit.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1145">3.107. SQL 1145</h3>
+<h3 id="SQL-1145">3.93. SQL 1145</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">The catalog name <catalog-name> is reserved for {project-name} metadata.</code></pre>
@@ -4179,7 +3867,7 @@ Change <catalog-name> to a name that is not reserved and resubmit.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1146">3.108. SQL 1146</h3>
+<h3 id="SQL-1146">3.94. SQL 1146</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Object <object-name> could not be altered because it is not a <object-type>.</code></pre>
@@ -4207,7 +3895,7 @@ a statement that is consistent with that type of object.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1147">3.109. SQL 1147</h3>
+<h3 id="SQL-1147">3.95. SQL 1147</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">System-generated column <column-name> of base table <table-name> cannot appear in a unique or primary key constraint.</code></pre>
@@ -4231,7 +3919,7 @@ SYSKEY column.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1148">3.110. SQL 1148</h3>
+<h3 id="SQL-1148">3.96. SQL 1148</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">System-generated column <column-name> of base table <table-name> cannot appear in a referential integrity constraint definition.</code></pre>
@@ -4256,7 +3944,7 @@ that is the SYSKEY, which is not supported.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1150">3.111. SQL 1150</h3>
+<h3 id="SQL-1150">3.97. SQL 1150</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Table <table-name> was not created as Partition Overlay Support could not generate volume names for the partitions to reside on.</code></pre>
@@ -4299,7 +3987,7 @@ without partitions is created when the volume names cannot be generated.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1151">3.112. SQL 1151</h3>
+<h3 id="SQL-1151">3.98. SQL 1151</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">POS (Partition Overlay Support) was not applied as volume names could not be generated for the partitions. So a simple table <table-name> was created without partitions.</code></pre>
@@ -4331,7 +4019,7 @@ CONTROL QUERY DEFAULT POS_LOCATIONS, and then retry the request.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1154">3.113. SQL 1154</h3>
+<h3 id="SQL-1154">3.99. SQL 1154</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Cannot create object <object-name> as the table size is too big to fit on the system.</code></pre>
@@ -4351,7 +4039,7 @@ the system and retry the statement.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1155">3.114. SQL 1155</h3>
+<h3 id="SQL-1155">3.100. SQL 1155</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Operation cannot be performed because <object-name> is not a synonym.</code></pre>
@@ -4369,7 +4057,7 @@ the system and retry the statement.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1156">3.115. SQL 1156</h3>
+<h3 id="SQL-1156">3.101. SQL 1156</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Synonym <name> does not exist or object type is invalid for the current operation.</code></pre>
@@ -4387,7 +4075,7 @@ that is not a table or view.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1157">3.116. SQL 1157</h3>
+<h3 id="SQL-1157">3.102. SQL 1157</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Synonym object <name> is the same as previous mapping.</code></pre>
@@ -4406,7 +4094,7 @@ is the same as its previous mapping.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1158">3.117. SQL 1158</h3>
+<h3 id="SQL-1158">3.103. SQL 1158</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">Synonym <name> already exists.</code></pre>
@@ -4424,7 +4112,7 @@ synonym of that name already exists.</p>
</div>
</div>
<div class="sect2">
-<h3 id="SQL-1159">3.118. SQL 1159</h3>
+<h3 id="SQL-1159">3.104. SQL 1159</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">The specified object <name> is not a table or a view. Please verify that the correct object was specified.</code></pre>
@@ -4442,7 +4130,7 @@ synonym of that name already exists.</p>
<div style="page-break-after: always;"></div>
</div>
<div class="sect2">
-<h3 id="SQL-1160">3.119. SQL 1160</h3>
+<h3 id="SQL-1160">3.105. SQL 1160</h3>
<div class="listingblock">
<div class="content">
<pre class="CodeRay highlight"><code data-lang="text">A mismatch between the NOT DROPPABLE PRIMARY KEY constraint and the STORE BY clause was detected. When both clauses are specified, the STORE BY key column list must be the same as, or a prefix of , the PRIMARY KEY column list. This mismatch is caused by differences between the columns themselves, the order of columns, or the ASC/DESC attribute.</code></pre>
@@ -4465,7 +4153,7 @@ key, do not specify a STORE BY clause. Correct the syntax and resubm
<TRUNCATED>