http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/443bbb76/docs/2.3.0/messages_guide/index.html ---------------------------------------------------------------------- diff --git a/docs/2.3.0/messages_guide/index.html b/docs/2.3.0/messages_guide/index.html index 36c652d..3817d92 100644 --- a/docs/2.3.0/messages_guide/index.html +++ b/docs/2.3.0/messages_guide/index.html @@ -580,197 +580,203 @@ table.CodeRay td.code>pre{padding:0} <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-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> -<li><a href="#SQL-1042">3.34. SQL 1042</a></li> -<li><a href="#SQL-1043">3.35. SQL 1043</a></li> -<li><a href="#SQL-1044">3.36. SQL 1044</a></li> -<li><a href="#SQL-1045">3.37. SQL 1045</a></li> -<li><a href="#SQL-1046">3.38. SQL 1046</a></li> -<li><a href="#SQL-1047">3.39. SQL 1047</a></li> -<li><a href="#SQL-1048">3.40. SQL 1048</a></li> -<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-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-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-1100">3.63. SQL 1100</a></li> -<li><a href="#SQL-1108">3.64. SQL 1108</a></li> -<li><a href="#SQL-1109">3.65. SQL 1109</a></li> -<li><a href="#SQL-1112">3.66. SQL 1112</a></li> -<li><a href="#SQL-1114">3.67. SQL 1114</a></li> -<li><a href="#SQL-1115">3.68. SQL 1115</a></li> -<li><a href="#SQL-1116">3.69. SQL 1116</a></li> -<li><a href="#SQL-1117">3.70. SQL 1117</a></li> -<li><a href="#SQL-1118">3.71. SQL 1118</a></li> -<li><a href="#SQL-1119">3.72. SQL 1119</a></li> -<li><a href="#SQL-1120">3.73. SQL 1120</a></li> -<li><a href="#SQL-1121">3.74. SQL 1121</a></li> -<li><a href="#SQL-1122">3.75. SQL 1122</a></li> -<li><a href="#SQL-1123">3.76. SQL 1123</a></li> -<li><a href="#SQL-1127">3.77. SQL 1127</a></li> -<li><a href="#SQL-1130">3.78. SQL 1130</a></li> -<li><a href="#SQL-1132">3.79. SQL 1132</a></li> -<li><a href="#SQL-1133">3.80. SQL 1133</a></li> -<li><a href="#SQL-1135">3.81. SQL 1135</a></li> -<li><a href="#SQL-1136">3.82. SQL 1136</a></li> -<li><a href="#SQL-1139">3.83. SQL 1139</a></li> -<li><a href="#SQL-1140">3.84. SQL 1140</a></li> -<li><a href="#SQL-1143">3.85. SQL 1143</a></li> -<li><a href="#SQL-1144">3.86. SQL 1144</a></li> -<li><a href="#SQL-1146">3.87. SQL 1146</a></li> -<li><a href="#SQL-1147">3.88. SQL 1147</a></li> -<li><a href="#SQL-1148">3.89. SQL 1148</a></li> -<li><a href="#SQL-1155">3.90. SQL 1155</a></li> -<li><a href="#SQL-1156">3.91. SQL 1156</a></li> -<li><a href="#SQL-1157">3.92. SQL 1157</a></li> -<li><a href="#SQL-1174">3.93. SQL 1174</a></li> -<li><a href="#SQL-1180">3.94. SQL 1180</a></li> -<li><a href="#SQL-1181">3.95. SQL 1181</a></li> -<li><a href="#SQL-1186">3.96. SQL 1186</a></li> -<li><a href="#SQL-1187">3.97. SQL 1187</a></li> -<li><a href="#SQL-1188">3.98. SQL 1188</a></li> -<li><a href="#SQL-1190">3.99. SQL 1190</a></li> -<li><a href="#SQL-1191">3.100. SQL 1191</a></li> -<li><a href="#SQL-1192">3.101. SQL 1192</a></li> -<li><a href="#SQL-1193">3.102. SQL 1193</a></li> -<li><a href="#SQL-1195">3.103. SQL 1195</a></li> -<li><a href="#SQL-1196">3.104. SQL 1196</a></li> -<li><a href="#SQL-1197">3.105. SQL 1197</a></li> -<li><a href="#SQL-1199">3.106. SQL 1199</a></li> -<li><a href="#SQL-1200">3.107. SQL 1200</a></li> -<li><a href="#SQL-1201">3.108. SQL 1201</a></li> -<li><a href="#SQL-1202">3.109. SQL 1202</a></li> -<li><a href="#SQL-1203">3.110. SQL 1203</a></li> -<li><a href="#SQL-1204">3.111. SQL 1204</a></li> -<li><a href="#SQL-1214">3.112. SQL 1214</a></li> -<li><a href="#SQL-1215">3.113. SQL 1215</a></li> -<li><a href="#SQL-1222">3.114. SQL 1222</a></li> -<li><a href="#SQL-1223">3.115. SQL 1223</a></li> -<li><a href="#SQL-1227">3.116. SQL 1227</a></li> -<li><a href="#SQL-1228">3.117. SQL 1228</a></li> -<li><a href="#SQL-1230">3.118. SQL 1230</a></li> -<li><a href="#SQL-1231">3.119. SQL 1231</a></li> -<li><a href="#SQL-1234">3.120. SQL 1234</a></li> -<li><a href="#SQL-1240">3.121. SQL 1240</a></li> -<li><a href="#SQL-1243">3.122. SQL 1243</a></li> -<li><a href="#SQL-1251">3.123. SQL 1251</a></li> -<li><a href="#SQL-1254">3.124. SQL 1254</a></li> -<li><a href="#SQL-1255">3.125. SQL 1255</a></li> -<li><a href="#SQL-1256">3.126. SQL 1256</a></li> -<li><a href="#SQL-1260">3.127. SQL 1260</a></li> -<li><a href="#SQL-1264">3.128. SQL 1264</a></li> -<li><a href="#SQL-1266">3.129. SQL 1266</a></li> -<li><a href="#SQL-1267">3.130. SQL 1267</a></li> -<li><a href="#SQL-1268">3.131. SQL 1268</a></li> -<li><a href="#SQL-1269">3.132. SQL 1269</a></li> -<li><a href="#SQL-1276">3.133. SQL 1276</a></li> -<li><a href="#SQL-1279">3.134. SQL 1279</a></li> -<li><a href="#SQL-1280">3.135. SQL 1280</a></li> -<li><a href="#SQL-1282">3.136. SQL 1282</a></li> -<li><a href="#SQL-1283">3.137. SQL 1283</a></li> -<li><a href="#SQL-1289">3.138. SQL 1289</a></li> -<li><a href="#SQL-1298">3.139. SQL 1298</a></li> -<li><a href="#SQL-1313">3.140. SQL 1313</a></li> -<li><a href="#SQL-1323">3.141. SQL 1323</a></li> -<li><a href="#SQL-1330">3.142. SQL 1330</a></li> -<li><a href="#SQL-1331">3.143. SQL 1331</a></li> -<li><a href="#SQL-1332">3.144. SQL 1332</a></li> -<li><a href="#SQL-1333">3.145. SQL 1333</a></li> -<li><a href="#SQL-1334">3.146. SQL 1334</a></li> -<li><a href="#SQL-1335">3.147. SQL 1335</a></li> -<li><a href="#SQL-1337">3.148. SQL 1337</a></li> -<li><a href="#SQL-1338">3.149. SQL 1338</a></li> -<li><a href="#SQL-1339">3.150. SQL 1339</a></li> -<li><a href="#SQL-1340">3.151. SQL 1340</a></li> -<li><a href="#SQL-1347">3.152. SQL 1347</a></li> -<li><a href="#SQL-1348">3.153. SQL 1348</a></li> -<li><a href="#SQL-1349">3.154. SQL 1349</a></li> -<li><a href="#SQL-1351">3.155. SQL 1351</a></li> -<li><a href="#SQL-1352">3.156. SQL 1352</a></li> -<li><a href="#SQL-1355">3.157. SQL 1355</a></li> -<li><a href="#SQL-1356">3.158. SQL 1356</a></li> -<li><a href="#SQL-1357">3.159. SQL 1357</a></li> -<li><a href="#SQL-1364">3.160. SQL 1364</a></li> -<li><a href="#SQL-1366">3.161. SQL 1366</a></li> -<li><a href="#SQL-1370">3.162. SQL 1370</a></li> -<li><a href="#SQL-1382">3.163. SQL 1382</a></li> -<li><a href="#SQL-1388">3.164. SQL 1388</a></li> -<li><a href="#SQL-1389">3.165. SQL 1389</a></li> -<li><a href="#SQL-1390">3.166. SQL 1390</a></li> -<li><a href="#SQL-1391">3.167. SQL 1391</a></li> -<li><a href="#SQL-1392">3.168. SQL 1392</a></li> -<li><a href="#SQL-1393">3.169. SQL 1393</a></li> -<li><a href="#SQL-1394">3.170. SQL 1394</a></li> -<li><a href="#SQL-1395">3.171. SQL 1395</a></li> -<li><a href="#SQL-1396">3.172. SQL 1396</a></li> -<li><a href="#SQL-1397">3.173. SQL 1397</a></li> -<li><a href="#SQL-1398">3.174. SQL 1398</a></li> -<li><a href="#SQL-1399">3.175. SQL 1399</a></li> -<li><a href="#SQL-1401">3.176. SQL 1401</a></li> -<li><a href="#SQL-1402">3.177. SQL 1402</a></li> -<li><a href="#SQL-1403">3.178. SQL 1403</a></li> -<li><a href="#SQL-1404">3.179. SQL 1404</a></li> -<li><a href="#SQL-1420">3.180. SQL 1420</a></li> -<li><a href="#SQL-1421">3.181. SQL 1421</a></li> -<li><a href="#SQL-1422">3.182. SQL 1422</a></li> -<li><a href="#SQL-1423">3.183. SQL 1423</a></li> -<li><a href="#SQL-1424">3.184. SQL 1424</a></li> -<li><a href="#SQL-1425">3.185. SQL 1425</a></li> -<li><a href="#SQL-1426">3.186. SQL 1426</a></li> -<li><a href="#SQL-1427">3.187. SQL 1427</a></li> -<li><a href="#SQL-1428">3.188. SQL 1428</a></li> -<li><a href="#SQL-1429">3.189. SQL 1429</a></li> -<li><a href="#SQL-1430">3.190. SQL 1430</a></li> -<li><a href="#SQL-1431">3.191. SQL 1431</a></li> -<li><a href="#SQL-1432">3.192. SQL 1432</a></li> -<li><a href="#SQL-1510">3.193. SQL 1510</a></li> -<li><a href="#SQL-1511">3.194. SQL 1511</a></li> -<li><a href="#SQL-1514">3.195. SQL 1514</a></li> -<li><a href="#SQL-1540">3.196. SQL 1540</a></li> -<li><a href="#SQL-1541">3.197. SQL 1541</a></li> -<li><a href="#SQL-1550">3.198. SQL 1550</a></li> -<li><a href="#SQL-1570">3.199. SQL 1570</a></li> -<li><a href="#SQL-1571">3.200. SQL 1571</a></li> -<li><a href="#SQL-1572">3.201. SQL 1572</a></li> -<li><a href="#SQL-1573">3.202. SQL 1573</a></li> -<li><a href="#SQL-1575">3.203. SQL 1575</a></li> -<li><a href="#SQL-1576">3.204. SQL 1576</a></li> -<li><a href="#SQL-1577">3.205. SQL 1577</a></li> -<li><a href="#SQL-1579">3.206. SQL 1579</a></li> -<li><a href="#SQL-1582">3.207. SQL 1582</a></li> -<li><a href="#SQL-1583">3.208. SQL 1583</a></li> -<li><a href="#SQL-1584">3.209. SQL 1584</a></li> -<li><a href="#SQL-1590">3.210. SQL 1590</a></li> -<li><a href="#SQL-1592">3.211. SQL 1592</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-1032">3.27. SQL 1032</a></li> +<li><a href="#SQL-1033">3.28. SQL 1033</a></li> +<li><a href="#SQL-1034">3.29. SQL 1034</a></li> +<li><a href="#SQL-1035">3.30. SQL 1035</a></li> +<li><a href="#SQL-1036">3.31. SQL 1036</a></li> +<li><a href="#SQL-1037">3.32. SQL 1037</a></li> +<li><a href="#SQL-1039">3.33. SQL 1039</a></li> +<li><a href="#SQL-1040">3.34. SQL 1040</a></li> +<li><a href="#SQL-1041">3.35. SQL 1041</a></li> +<li><a href="#SQL-1042">3.36. SQL 1042</a></li> +<li><a href="#SQL-1043">3.37. SQL 1043</a></li> +<li><a href="#SQL-1044">3.38. SQL 1044</a></li> +<li><a href="#SQL-1045">3.39. SQL 1045</a></li> +<li><a href="#SQL-1046">3.40. SQL 1046</a></li> +<li><a href="#SQL-1047">3.41. SQL 1047</a></li> +<li><a href="#SQL-1048">3.42. SQL 1048</a></li> +<li><a href="#SQL-1049">3.43. SQL 1049</a></li> +<li><a href="#SQL-1050">3.44. SQL 1050</a></li> +<li><a href="#SQL-1051">3.45. SQL 1051</a></li> +<li><a href="#SQL-1052">3.46. SQL 1052</a></li> +<li><a href="#SQL-1053">3.47. SQL 1053</a></li> +<li><a href="#SQL-1055">3.48. SQL 1055</a></li> +<li><a href="#SQL-1058">3.49. SQL 1058</a></li> +<li><a href="#SQL-1059">3.50. SQL 1059</a></li> +<li><a href="#SQL-1062">3.51. SQL 1062</a></li> +<li><a href="#SQL-1068">3.52. SQL 1068</a></li> +<li><a href="#SQL-1069">3.53. SQL 1069</a></li> +<li><a href="#SQL-1070">3.54. SQL 1070</a></li> +<li><a href="#SQL-1071">3.55. SQL 1071</a></li> +<li><a href="#SQL-1073">3.56. SQL 1073</a></li> +<li><a href="#SQL-1080">3.57. SQL 1080</a></li> +<li><a href="#SQL-1081">3.58. SQL 1081</a></li> +<li><a href="#SQL-1082">3.59. SQL 1082</a></li> +<li><a href="#SQL-1083">3.60. SQL 1083</a></li> +<li><a href="#SQL-1084">3.61. SQL 1084</a></li> +<li><a href="#SQL-1089">3.62. SQL 1089</a></li> +<li><a href="#SQL-1090">3.63. SQL 1090</a></li> +<li><a href="#SQL-1098">3.64. SQL 1098</a></li> +<li><a href="#SQL-1099">3.65. SQL 1099</a></li> +<li><a href="#SQL-1100">3.66. SQL 1100</a></li> +<li><a href="#SQL-1108">3.67. SQL 1108</a></li> +<li><a href="#SQL-1109">3.68. SQL 1109</a></li> +<li><a href="#SQL-1112">3.69. SQL 1112</a></li> +<li><a href="#SQL-1114">3.70. SQL 1114</a></li> +<li><a href="#SQL-1115">3.71. SQL 1115</a></li> +<li><a href="#SQL-1116">3.72. SQL 1116</a></li> +<li><a href="#SQL-1117">3.73. SQL 1117</a></li> +<li><a href="#SQL-1118">3.74. SQL 1118</a></li> +<li><a href="#SQL-1119">3.75. SQL 1119</a></li> +<li><a href="#SQL-1120">3.76. SQL 1120</a></li> +<li><a href="#SQL-1121">3.77. SQL 1121</a></li> +<li><a href="#SQL-1122">3.78. SQL 1122</a></li> +<li><a href="#SQL-1123">3.79. SQL 1123</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-1135">3.84. SQL 1135</a></li> +<li><a href="#SQL-1136">3.85. SQL 1136</a></li> +<li><a href="#SQL-1139">3.86. SQL 1139</a></li> +<li><a href="#SQL-1140">3.87. SQL 1140</a></li> +<li><a href="#SQL-1143">3.88. SQL 1143</a></li> +<li><a href="#SQL-1144">3.89. SQL 1144</a></li> +<li><a href="#SQL-1146">3.90. SQL 1146</a></li> +<li><a href="#SQL-1147">3.91. SQL 1147</a></li> +<li><a href="#SQL-1148">3.92. SQL 1148</a></li> +<li><a href="#SQL-1155">3.93. SQL 1155</a></li> +<li><a href="#SQL-1156">3.94. SQL 1156</a></li> +<li><a href="#SQL-1157">3.95. SQL 1157</a></li> +<li><a href="#SQL-1174">3.96. SQL 1174</a></li> +<li><a href="#SQL-1180">3.97. SQL 1180</a></li> +<li><a href="#SQL-1181">3.98. SQL 1181</a></li> +<li><a href="#SQL-1186">3.99. SQL 1186</a></li> +<li><a href="#SQL-1187">3.100. SQL 1187</a></li> +<li><a href="#SQL-1188">3.101. SQL 1188</a></li> +<li><a href="#SQL-1190">3.102. SQL 1190</a></li> +<li><a href="#SQL-1191">3.103. SQL 1191</a></li> +<li><a href="#SQL-1192">3.104. SQL 1192</a></li> +<li><a href="#SQL-1193">3.105. SQL 1193</a></li> +<li><a href="#SQL-1195">3.106. SQL 1195</a></li> +<li><a href="#SQL-1196">3.107. SQL 1196</a></li> +<li><a href="#SQL-1197">3.108. SQL 1197</a></li> +<li><a href="#SQL-1199">3.109. SQL 1199</a></li> +<li><a href="#SQL-1200">3.110. SQL 1200</a></li> +<li><a href="#SQL-1201">3.111. SQL 1201</a></li> +<li><a href="#SQL-1202">3.112. SQL 1202</a></li> +<li><a href="#SQL-1203">3.113. SQL 1203</a></li> +<li><a href="#SQL-1204">3.114. SQL 1204</a></li> +<li><a href="#SQL-1214">3.115. SQL 1214</a></li> +<li><a href="#SQL-1215">3.116. SQL 1215</a></li> +<li><a href="#SQL-1220">3.117. SQL 1220</a></li> +<li><a href="#SQL-1222">3.118. SQL 1222</a></li> +<li><a href="#SQL-1223">3.119. SQL 1223</a></li> +<li><a href="#SQL-1227">3.120. SQL 1227</a></li> +<li><a href="#SQL-1228">3.121. SQL 1228</a></li> +<li><a href="#SQL-1230">3.122. SQL 1230</a></li> +<li><a href="#SQL-1231">3.123. SQL 1231</a></li> +<li><a href="#SQL-1234">3.124. SQL 1234</a></li> +<li><a href="#SQL-1240">3.125. SQL 1240</a></li> +<li><a href="#SQL-1243">3.126. SQL 1243</a></li> +<li><a href="#SQL-1251">3.127. SQL 1251</a></li> +<li><a href="#SQL-1254">3.128. SQL 1254</a></li> +<li><a href="#SQL-1255">3.129. SQL 1255</a></li> +<li><a href="#SQL-1256">3.130. SQL 1256</a></li> +<li><a href="#SQL-1260">3.131. SQL 1260</a></li> +<li><a href="#SQL-1264">3.132. SQL 1264</a></li> +<li><a href="#SQL-1266">3.133. SQL 1266</a></li> +<li><a href="#SQL-1267">3.134. SQL 1267</a></li> +<li><a href="#SQL-1268">3.135. SQL 1268</a></li> +<li><a href="#SQL-1269">3.136. SQL 1269</a></li> +<li><a href="#SQL-1276">3.137. SQL 1276</a></li> +<li><a href="#SQL-1279">3.138. SQL 1279</a></li> +<li><a href="#SQL-1280">3.139. SQL 1280</a></li> +<li><a href="#SQL-1282">3.140. SQL 1282</a></li> +<li><a href="#SQL-1283">3.141. SQL 1283</a></li> +<li><a href="#SQL-1289">3.142. SQL 1289</a></li> +<li><a href="#SQL-1298">3.143. SQL 1298</a></li> +<li><a href="#SQL-1313">3.144. SQL 1313</a></li> +<li><a href="#SQL-1323">3.145. SQL 1323</a></li> +<li><a href="#SQL-1330">3.146. SQL 1330</a></li> +<li><a href="#SQL-1331">3.147. SQL 1331</a></li> +<li><a href="#SQL-1332">3.148. SQL 1332</a></li> +<li><a href="#SQL-1333">3.149. SQL 1333</a></li> +<li><a href="#SQL-1334">3.150. SQL 1334</a></li> +<li><a href="#SQL-1335">3.151. SQL 1335</a></li> +<li><a href="#SQL-1337">3.152. SQL 1337</a></li> +<li><a href="#SQL-1338">3.153. SQL 1338</a></li> +<li><a href="#SQL-1339">3.154. SQL 1339</a></li> +<li><a href="#SQL-1340">3.155. SQL 1340</a></li> +<li><a href="#SQL-1347">3.156. SQL 1347</a></li> +<li><a href="#SQL-1348">3.157. SQL 1348</a></li> +<li><a href="#SQL-1349">3.158. SQL 1349</a></li> +<li><a href="#SQL-1351">3.159. SQL 1351</a></li> +<li><a href="#SQL-1352">3.160. SQL 1352</a></li> +<li><a href="#SQL-1355">3.161. SQL 1355</a></li> +<li><a href="#SQL-1356">3.162. SQL 1356</a></li> +<li><a href="#SQL-1357">3.163. SQL 1357</a></li> +<li><a href="#SQL-1364">3.164. SQL 1364</a></li> +<li><a href="#SQL-1366">3.165. SQL 1366</a></li> +<li><a href="#SQL-1370">3.166. SQL 1370</a></li> +<li><a href="#SQL-1382">3.167. SQL 1382</a></li> +<li><a href="#SQL-1388">3.168. SQL 1388</a></li> +<li><a href="#SQL-1389">3.169. SQL 1389</a></li> +<li><a href="#SQL-1390">3.170. SQL 1390</a></li> +<li><a href="#SQL-1391">3.171. SQL 1391</a></li> +<li><a href="#SQL-1392">3.172. SQL 1392</a></li> +<li><a href="#SQL-1393">3.173. SQL 1393</a></li> +<li><a href="#SQL-1394">3.174. SQL 1394</a></li> +<li><a href="#SQL-1395">3.175. SQL 1395</a></li> +<li><a href="#SQL-1396">3.176. SQL 1396</a></li> +<li><a href="#SQL-1397">3.177. SQL 1397</a></li> +<li><a href="#SQL-1398">3.178. SQL 1398</a></li> +<li><a href="#SQL-1399">3.179. SQL 1399</a></li> +<li><a href="#SQL-1401">3.180. SQL 1401</a></li> +<li><a href="#SQL-1402">3.181. SQL 1402</a></li> +<li><a href="#SQL-1403">3.182. SQL 1403</a></li> +<li><a href="#SQL-1404">3.183. SQL 1404</a></li> +<li><a href="#SQL-1420">3.184. SQL 1420</a></li> +<li><a href="#SQL-1421">3.185. SQL 1421</a></li> +<li><a href="#SQL-1422">3.186. SQL 1422</a></li> +<li><a href="#SQL-1423">3.187. SQL 1423</a></li> +<li><a href="#SQL-1424">3.188. SQL 1424</a></li> +<li><a href="#SQL-1425">3.189. SQL 1425</a></li> +<li><a href="#SQL-1426">3.190. SQL 1426</a></li> +<li><a href="#SQL-1427">3.191. SQL 1427</a></li> +<li><a href="#SQL-1428">3.192. SQL 1428</a></li> +<li><a href="#SQL-1429">3.193. SQL 1429</a></li> +<li><a href="#SQL-1430">3.194. SQL 1430</a></li> +<li><a href="#SQL-1431">3.195. SQL 1431</a></li> +<li><a href="#SQL-1432">3.196. SQL 1432</a></li> +<li><a href="#SQL-1510">3.197. SQL 1510</a></li> +<li><a href="#SQL-1511">3.198. SQL 1511</a></li> +<li><a href="#SQL-1514">3.199. SQL 1514</a></li> +<li><a href="#SQL-1540">3.200. SQL 1540</a></li> +<li><a href="#SQL-1541">3.201. SQL 1541</a></li> +<li><a href="#SQL-1550">3.202. SQL 1550</a></li> +<li><a href="#SQL-1570">3.203. SQL 1570</a></li> +<li><a href="#SQL-1571">3.204. SQL 1571</a></li> +<li><a href="#SQL-1572">3.205. SQL 1572</a></li> +<li><a href="#SQL-1573">3.206. SQL 1573</a></li> +<li><a href="#SQL-1575">3.207. SQL 1575</a></li> +<li><a href="#SQL-1576">3.208. SQL 1576</a></li> +<li><a href="#SQL-1577">3.209. SQL 1577</a></li> +<li><a href="#SQL-1579">3.210. SQL 1579</a></li> +<li><a href="#SQL-1582">3.211. SQL 1582</a></li> +<li><a href="#SQL-1583">3.212. SQL 1583</a></li> +<li><a href="#SQL-1584">3.213. SQL 1584</a></li> +<li><a href="#SQL-1590">3.214. SQL 1590</a></li> +<li><a href="#SQL-1592">3.215. SQL 1592</a></li> +<li><a href="#SQL-1719">3.216. SQL 1719</a></li> +<li><a href="#SQL-1720">3.217. SQL 1720</a></li> </ul> </li> <li><a href="#trafodion-compiler-messages">4. Trafodion Compiler Messages (2000 through 2999)</a> @@ -2262,7 +2268,30 @@ the object.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1027">3.21. SQL 1027</h3> +<h3 id="SQL-1026">3.21. SQL 1026</h3> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">Specified object name <object-name> is invalid for this command.</code></pre> +</div> +</div> +<div class="paragraph"> +<p>Where <object-name> is the name of the object you specified.</p> +</div> +<div class="paragraph"> +<p><strong>Cause:</strong> You attempted to register or unregister a Hive or HBase table, but the object name +was not of the appropriate kind. For example, REGISTER HIVE TABLE TRAFODION.SCH.T1 will get this +error because objects in the TRAFODION catalog are native Trafodion objects.</p> +</div> +<div class="paragraph"> +<p><strong>Effect:</strong> The operation fails.</p> +</div> +<div class="paragraph"> +<p><strong>Recovery:</strong> Correct the statement and resubmit.</p> +</div> +<div style="page-break-after: always;"></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 view <view-name> was created before column privileges were supported. To grant column privileges, please recreate the view.</code></pre> @@ -2282,10 +2311,9 @@ on an earlier release of the Trafodion software, before column privileges were s <div class="paragraph"> <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.22. SQL 1028</h3> +<h3 id="SQL-1028">3.23. 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> @@ -2306,9 +2334,10 @@ objects.</p> <p><strong>Recovery:</strong> Either drop all the objects in <schema-name> and resubmit the statement, or resubmit the drop statement using the CASCADE option.</p> </div> +<div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1029">3.23. SQL 1029</h3> +<h3 id="SQL-1029">3.24. 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> @@ -2327,10 +2356,9 @@ accompanying error messages to determine the cause.</p> <div class="paragraph"> <p><strong>Recovery:</strong> Apply the recovery of the accompanying error messages.</p> </div> -<div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1030">3.24. SQL 1030</h3> +<h3 id="SQL-1030">3.25. SQL 1030</h3> <div class="listingblock"> <div class="content"> <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> @@ -2353,9 +2381,10 @@ is too long for HBase.</p> <div class="paragraph"> <p><strong>Recovery:</strong> Use a shorter name and resubmit.</p> </div> +<div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1031">3.25. SQL 1031</h3> +<h3 id="SQL-1031">3.26. 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> @@ -2373,10 +2402,9 @@ is too long for HBase.</p> <div class="paragraph"> <p><strong>Recovery:</strong> Apply the recovery of the accompanying error message.</p> </div> -<div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1032">3.26. SQL 1032</h3> +<h3 id="SQL-1032">3.27. SQL 1032</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">The DISPLAY command completes and the query is not executed.</code></pre> @@ -2394,9 +2422,29 @@ the query is not executed.</p> <p><strong>Recovery:</strong> If you wish to execute the query, resubmit without the DISPLAY command.</p> </div> +<div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1034">3.27. SQL 1034</h3> +<h3 id="SQL-1033">3.28. SQL 1033</h3> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">Unable to obtain comments.</code></pre> +</div> +</div> +<div class="paragraph"> +<p><strong>Cause:</strong> You attempted a DDL or SHOWDDL operation but Trafodion +could not retrieve comment 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> +<div class="sect2"> +<h3 id="SQL-1034">3.29. SQL 1034</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Unable to obtain privileges.</code></pre> @@ -2416,7 +2464,7 @@ Additional error messages may give insight to the cause.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1035">3.28. SQL 1035</h3> +<h3 id="SQL-1035">3.30. SQL 1035</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Catalog <catalog-name> already exists.</code></pre> @@ -2438,7 +2486,7 @@ catalog name and resubmit.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1036">3.29. SQL 1036</h3> +<h3 id="SQL-1036">3.31. SQL 1036</h3> <div class="listingblock"> <div class="content"> <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> @@ -2463,7 +2511,7 @@ this request might create a circular dependency.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1037">3.30. SQL 1037</h3> +<h3 id="SQL-1037">3.32. SQL 1037</h3> <div class="listingblock"> <div class="content"> <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> @@ -2486,7 +2534,7 @@ original authorization ID and resubmit.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1039">3.31. SQL 1039</h3> +<h3 id="SQL-1039">3.33. SQL 1039</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">No privileges were revoked. You lack the grant option for the specified privilege(s).</code></pre> @@ -2506,7 +2554,7 @@ that has grant option for these privileges and resubmit.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1040">3.32. SQL 1040</h3> +<h3 id="SQL-1040">3.34. SQL 1040</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">The use of ALTER on metadata tables is not permitted.</code></pre> @@ -2524,7 +2572,7 @@ of the Trafodion database metadata. Such tables cannot be altered.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1041">3.33. SQL 1041</h3> +<h3 id="SQL-1041">3.35. SQL 1041</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">The primary key has already been defined.</code></pre> @@ -2542,7 +2590,7 @@ a primary key.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1042">3.34. SQL 1042</h3> +<h3 id="SQL-1042">3.36. SQL 1042</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">All PRIMARY KEY or UNIQUE constraint columns must be NOT NULL.</code></pre> @@ -2562,7 +2610,7 @@ columns that are in the PRIMARY KEY and UNIQUE constraints.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1043">3.35. SQL 1043</h3> +<h3 id="SQL-1043">3.37. SQL 1043</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Constraint <constraint-name> already exists.</code></pre> @@ -2586,7 +2634,7 @@ SHOWDDL to see the names of existing constraints.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1044">3.36. SQL 1044</h3> +<h3 id="SQL-1044">3.38. SQL 1044</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Constraint <constraint-name> could not be created because the referenced columns in the referenced table are not part of a unique constraint.</code></pre> @@ -2610,7 +2658,7 @@ constraint in the referenced table.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1045">3.37. SQL 1045</h3> +<h3 id="SQL-1045">3.39. SQL 1045</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">The unique constraint cannot be used because it is deferrable.</code></pre> @@ -2630,7 +2678,7 @@ Distribution List</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1046">3.38. SQL 1046</h3> +<h3 id="SQL-1046">3.40. SQL 1046</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Referenced and referencing column lists do not match for constraint <constraint-name>.</code></pre> @@ -2654,7 +2702,7 @@ matches the list of referenced columns.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1047">3.39. SQL 1047</h3> +<h3 id="SQL-1047">3.41. SQL 1047</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Request failed. Dependent view <view-name> exists.</code></pre> @@ -2678,7 +2726,7 @@ on the DROP statement for the object.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1048">3.40. SQL 1048</h3> +<h3 id="SQL-1048">3.42. SQL 1048</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">The statement currently supports only RESTRICT behavior.</code></pre> @@ -2698,7 +2746,7 @@ the drop behavior (which will default to RESTRICT).</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1049">3.41. SQL 1049</h3> +<h3 id="SQL-1049">3.43. SQL 1049</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Constraint cannot be dropped because it was specified to be NOT DROPPABLE.</code></pre> @@ -2715,7 +2763,7 @@ the drop behavior (which will default to RESTRICT).</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1050">3.42. SQL 1050</h3> +<h3 id="SQL-1050">3.44. SQL 1050</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Constraint cannot be dropped because it is used as a referenced object for a foreign key.</code></pre> @@ -2736,7 +2784,7 @@ use the CASCADE option for the DROP CONSTRAINT command.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1051">3.43. SQL 1051</h3> +<h3 id="SQL-1051">3.45. SQL 1051</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">You do not have the required privilege(s) on <object-name>.</code></pre> @@ -2758,7 +2806,7 @@ security needed to create a view or trigger.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1052">3.44. SQL 1052</h3> +<h3 id="SQL-1052">3.46. 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> @@ -2778,7 +2826,7 @@ table you specified. Correct the name and resubmit.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1053">3.45. SQL 1053</h3> +<h3 id="SQL-1053">3.47. 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> @@ -2801,7 +2849,7 @@ statement.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1055">3.46. SQL 1055</h3> +<h3 id="SQL-1055">3.48. SQL 1055</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Object <component-name> already exists.</code></pre> @@ -2823,7 +2871,7 @@ Trafodion database but this component already exists.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1058">3.47. SQL 1058</h3> +<h3 id="SQL-1058">3.49. SQL 1058</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Unable to create histogram table <table-name>.</code></pre> @@ -2847,7 +2895,7 @@ error messages.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1059">3.48. SQL 1059</h3> +<h3 id="SQL-1059">3.50. 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> @@ -2872,7 +2920,7 @@ CASCADE option.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1062">3.49. SQL 1062</h3> +<h3 id="SQL-1062">3.51. SQL 1062</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Dropping metadata or reserved schema <schema-name> is not allowed.</code></pre> @@ -2893,7 +2941,7 @@ database metadata or is reserved.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1068">3.50. SQL 1068</h3> +<h3 id="SQL-1068">3.52. SQL 1068</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Initialize authorization completed with warnings.</code></pre> @@ -2913,7 +2961,7 @@ accompanied by additional warning messages which report the specifics.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1069">3.51. SQL 1069</h3> +<h3 id="SQL-1069">3.53. SQL 1069</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Schema <schema-name> could not be dropped. <details></code></pre> @@ -2939,7 +2987,7 @@ CLEANUP SCHEMA command may be used to recover in these cases.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1070">3.52. SQL 1070</h3> +<h3 id="SQL-1070">3.54. 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> @@ -2964,7 +3012,31 @@ system error <error-number>.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1073">3.53. SQL 1073</h3> +<h3 id="SQL-1071">3.55. SQL 1071</h3> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">View usage information for the following hive tables could not be set. Make sure that an external table either already exists or implicit creation has not been disabled. Hive tables: <hive-tables></code></pre> +</div> +</div> +<div class="paragraph"> +<p>Where <hive-tables> is a list of Hive table names.</p> +</div> +<div class="paragraph"> +<p><strong>Cause:</strong> You attempted to create a view referencing the listed Hive tables, but the Hive tables do not have external tables defined within Trafodion +or have not been registered within Trafodion, and automatic registration has been turned off. (CQD HIVE_NO_REGISTER_OBJECTS controls whether automatic +registration is enabled. If this CQD is 'ON' it has been disabled.)</p> +</div> +<div class="paragraph"> +<p><strong>Effect:</strong> The operation fails.</p> +</div> +<div class="paragraph"> +<p><strong>Recovery:</strong> Either register or create external tables within Trafodion for the Hive tables listed, then resubmit. Alternatively, set +CQD HIVE_NO_REGISTER_OBJECTS 'OFF' and resubmit.</p> +</div> +<div style="page-break-after: always;"></div> +</div> +<div class="sect2"> +<h3 id="SQL-1073">3.56. SQL 1073</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Schema <schema-name> was partially dropped. Use CLEANUP SCHEMA to remove remaining entries.</code></pre> @@ -2982,7 +3054,7 @@ was only able to partially drop it.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1080">3.54. SQL 1080</h3> +<h3 id="SQL-1080">3.57. SQL 1080</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">The DDL request has duplicate references to column <column-name>.</code></pre> @@ -3006,7 +3078,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.55. SQL 1081</h3> +<h3 id="SQL-1081">3.58. 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> @@ -3029,7 +3101,7 @@ data could not be loaded into the index by the Call-level interface </div> </div> <div class="sect2"> -<h3 id="SQL-1082">3.56. SQL 1082</h3> +<h3 id="SQL-1082">3.59. 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> @@ -3055,7 +3127,7 @@ constraint, remove that data and resubmit.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1083">3.57. SQL 1083</h3> +<h3 id="SQL-1083">3.60. 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> @@ -3076,7 +3148,7 @@ resubmit.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1084">3.58. SQL 1084</h3> +<h3 id="SQL-1084">3.61. 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> @@ -3098,7 +3170,7 @@ for <column-name>.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1089">3.59. SQL 1089</h3> +<h3 id="SQL-1089">3.62. 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> @@ -3117,7 +3189,7 @@ list and resubmit the statement.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1090">3.60. SQL 1090</h3> +<h3 id="SQL-1090">3.63. 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> @@ -3137,7 +3209,7 @@ referencing the primary key of the same table.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1098">3.61. SQL 1098</h3> +<h3 id="SQL-1098">3.64. SQL 1098</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Partition key (<key>) already specified for object <table-name>.</code></pre> @@ -3162,7 +3234,7 @@ partitions to have the same first key, and resubmit.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1099">3.62. SQL 1099</h3> +<h3 id="SQL-1099">3.65. 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> @@ -3185,7 +3257,7 @@ unnamed column and resubmit.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1100">3.63. SQL 1100</h3> +<h3 id="SQL-1100">3.66. SQL 1100</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">LOB column <column-name> cannot be specified in an alter operation.</code></pre> @@ -3206,7 +3278,7 @@ on a LOB column. This is not permitted.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1108">3.64. SQL 1108</h3> +<h3 id="SQL-1108">3.67. 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> @@ -3233,7 +3305,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.65. SQL 1109</h3> +<h3 id="SQL-1109">3.68. 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> @@ -3255,7 +3327,7 @@ and resubmit.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1112">3.66. SQL 1112</h3> +<h3 id="SQL-1112">3.69. 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> @@ -3275,7 +3347,7 @@ reissue the statement.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1114">3.67. SQL 1114</h3> +<h3 id="SQL-1114">3.70. 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> @@ -3301,7 +3373,7 @@ the cause.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1115">3.68. SQL 1115</h3> +<h3 id="SQL-1115">3.71. 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> @@ -3331,7 +3403,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.69. SQL 1116</h3> +<h3 id="SQL-1116">3.72. 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> @@ -3353,7 +3425,7 @@ STORE BY, or PARTITION BY clause.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1117">3.70. SQL 1117</h3> +<h3 id="SQL-1117">3.73. 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> @@ -3371,7 +3443,7 @@ STORE BY, or PARTITION BY clause.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1118">3.71. SQL 1118</h3> +<h3 id="SQL-1118">3.74. 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 a reserved system schema.</code></pre> @@ -3391,7 +3463,7 @@ STORE BY, or PARTITION BY clause.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1119">3.72. SQL 1119</h3> +<h3 id="SQL-1119">3.75. 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> @@ -3415,7 +3487,7 @@ destroy the database.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1120">3.73. SQL 1120</h3> +<h3 id="SQL-1120">3.76. SQL 1120</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Use of an approximate numeric datatype (float, real, double precision) in a partitioning key or salt clause is not allowed.</code></pre> @@ -3434,7 +3506,7 @@ for the partitioning key or salt column.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1121">3.74. SQL 1121</h3> +<h3 id="SQL-1121">3.77. 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> @@ -3456,7 +3528,7 @@ partition.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1122">3.75. SQL 1122</h3> +<h3 id="SQL-1122">3.78. 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> @@ -3484,7 +3556,7 @@ number of user-defined key columns, <key-col-number>.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1123">3.76. SQL 1123</h3> +<h3 id="SQL-1123">3.79. 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> @@ -3509,7 +3581,7 @@ contains an element that is not supported.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1127">3.77. 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> does not exist, is inaccessible or is not a base table. Please verify that the correct table was specified.</code></pre> @@ -3532,7 +3604,7 @@ is inaccessible, or is not a base table.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1130">3.78. 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> @@ -3550,7 +3622,7 @@ without specifying a default value.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1132">3.79. 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 be declared with both DEFAULT NULL and NOT NULL.</code></pre> @@ -3570,7 +3642,7 @@ NULL and resubmit.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1133">3.80. 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 the super ID can perform this operation.</code></pre> @@ -3589,7 +3661,7 @@ only by the super ID.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1135">3.81. SQL 1135</h3> +<h3 id="SQL-1135">3.84. 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> @@ -3611,7 +3683,7 @@ resubmit.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1136">3.82. SQL 1136</h3> +<h3 id="SQL-1136">3.85. 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> @@ -3632,7 +3704,7 @@ the primary key.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1139">3.83. SQL 1139</h3> +<h3 id="SQL-1139">3.86. 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> @@ -3658,7 +3730,7 @@ any system-generated column and resubmit.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1140">3.84. SQL 1140</h3> +<h3 id="SQL-1140">3.87. 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> @@ -3687,7 +3759,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-1143">3.85. SQL 1143</h3> +<h3 id="SQL-1143">3.88. 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 that violates the constraint, please use the following DML statement: <statement-text></code></pre> @@ -3722,7 +3794,7 @@ referential constraint definition and resubmit.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1144">3.86. SQL 1144</h3> +<h3 id="SQL-1144">3.89. 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> @@ -3753,7 +3825,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-1146">3.87. SQL 1146</h3> +<h3 id="SQL-1146">3.90. 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 either does not exist or is not a table.</code></pre> @@ -3775,7 +3847,7 @@ either is not a table, or the table does not exist.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1147">3.88. SQL 1147</h3> +<h3 id="SQL-1147">3.91. 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> @@ -3799,7 +3871,7 @@ SYSKEY column.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1148">3.89. SQL 1148</h3> +<h3 id="SQL-1148">3.92. 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> @@ -3824,7 +3896,7 @@ that is the SYSKEY, which is not supported.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1155">3.90. SQL 1155</h3> +<h3 id="SQL-1155">3.93. 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> @@ -3842,7 +3914,7 @@ that is the SYSKEY, which is not supported.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1156">3.91. SQL 1156</h3> +<h3 id="SQL-1156">3.94. SQL 1156</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Object <object-name> does not have columns.</code></pre> @@ -3859,7 +3931,7 @@ that is the SYSKEY, which is not supported.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1157">3.92. SQL 1157</h3> +<h3 id="SQL-1157">3.95. 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> @@ -3877,7 +3949,7 @@ is the same as its previous mapping.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1174">3.93. SQL 1174</h3> +<h3 id="SQL-1174">3.96. SQL 1174</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">An unsupported data type was encountered on this operation.</code></pre> @@ -3897,7 +3969,7 @@ due to an incomplete implementation of support for a particular column type.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1180">3.94. SQL 1180</h3> +<h3 id="SQL-1180">3.97. SQL 1180</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Trying to create an external <kind> table with a different schema or table name (<table-name>) than the source table (<source-table-name>). The external schema and table name must be the same as the source.</code></pre> @@ -3925,7 +3997,7 @@ same as the source table schema.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1181">3.95. SQL 1181</h3> +<h3 id="SQL-1181">3.98. SQL 1181</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Trying to create a schema with name <schema-name> to store the definition of a native HIVE or HBASE table and the name is too long. Maximum length supported is <max-length>.</code></pre> @@ -3949,7 +4021,7 @@ same as the source table schema.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1186">3.96. SQL 1186</h3> +<h3 id="SQL-1186">3.99. SQL 1186</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Column <column-name> is of type <column-data-type> which is not compatible with the default value's type, <value-datatype>.</code></pre> @@ -3977,7 +4049,7 @@ default to be compatible types and resubmit.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1187">3.97. SQL 1187</h3> +<h3 id="SQL-1187">3.100. SQL 1187</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">The schema name <schema-name> is reserved for SQL metadata.</code></pre> @@ -4000,7 +4072,7 @@ names. Choose a name that is not reserved and reissue the CREATE statement.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1188">3.98. SQL 1188</h3> +<h3 id="SQL-1188">3.101. SQL 1188</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Referential integrity constraint <constraint-name> for table <table-name> could not be created due to circular dependency: <dependency-information>.</code></pre> @@ -4028,7 +4100,7 @@ indirectly.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1190">3.99. SQL 1190</h3> +<h3 id="SQL-1190">3.102. SQL 1190</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Failed to initialize Hive metadata. Call to <function> returned error <optional-symbol>(<error-number>). Cause: <diagnostics>.</code></pre> @@ -4059,7 +4131,7 @@ cause of this error is that the Hive metadata server is down.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1191">3.100. SQL 1191</h3> +<h3 id="SQL-1191">3.103. SQL 1191</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">SERIALIZE option is not yet supported for <data-type> datatype.</code></pre> @@ -4081,7 +4153,7 @@ support columns of the given data type with the SERIALIZED attribute.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1192">3.101. SQL 1192</h3> +<h3 id="SQL-1192">3.104. SQL 1192</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Failed to retrieve data from Hive metastore. Call to <function> returned error <optional-symbol>(<error-number>). Cause: <diagnostics>.</code></pre> @@ -4113,7 +4185,7 @@ operation to the Trafodion User Distribution List.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1193">3.102. SQL 1193</h3> +<h3 id="SQL-1193">3.105. SQL 1193</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">The <type-of-string> specified in the <clause-name> clause must be identical to the primary key for a Trafodion table.</code></pre> @@ -4137,7 +4209,7 @@ overlap in meaning. Trafodion requires the former construct to match the latter </div> </div> <div class="sect2"> -<h3 id="SQL-1195">3.103. SQL 1195</h3> +<h3 id="SQL-1195">3.106. SQL 1195</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Column <column-name> is not allowed as a salt column. Only primary key columns or STORE BY columns are allowed.</code></pre> @@ -4158,7 +4230,7 @@ overlap in meaning. Trafodion requires the former construct to match the latter <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1196">3.104. SQL 1196</h3> +<h3 id="SQL-1196">3.107. SQL 1196</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">The number of salt partitions must be between <lower-bound> and <upper-bound> inclusive.</code></pre> @@ -4182,7 +4254,7 @@ Trafodion supports.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1197">3.105. SQL 1197</h3> +<h3 id="SQL-1197">3.108. SQL 1197</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">The location <location-1> for <stored-procedure-name> does not match with another location <location-2> specified. All location specifications must be identical.</code></pre> @@ -4207,7 +4279,7 @@ operation to the Trafodion User Distribution List.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1199">3.106. SQL 1199</h3> +<h3 id="SQL-1199">3.109. SQL 1199</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">The PARTITION BY clause is not allowed for a Trafodion table.</code></pre> @@ -4224,7 +4296,7 @@ operation to the Trafodion User Distribution List.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1200">3.107. SQL 1200</h3> +<h3 id="SQL-1200">3.110. SQL 1200</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">An error occurred while reading HDFS file statistics for Hive table <table-name>. Cause: <diagnostics>.</code></pre> @@ -4249,7 +4321,7 @@ A failure occurred at the HDFS or Hive level. The diagnostics contain more infor <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1201">3.108. SQL 1201</h3> +<h3 id="SQL-1201">3.111. SQL 1201</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Salted index <index-name> cannot be unique.</code></pre> @@ -4270,7 +4342,7 @@ SALT LIKE TABLE is not allowed for unique indexes.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1202">3.109. SQL 1202</h3> +<h3 id="SQL-1202">3.112. SQL 1202</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Index <index-name> cannot be salted like a table since table <table-name> is not salted.</code></pre> @@ -4295,7 +4367,7 @@ a table that is not salted.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1203">3.110. SQL 1203</h3> +<h3 id="SQL-1203">3.113. SQL 1203</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">HBASE_OPTIONS clause in CREATE statement is longer than 6000 characters. Object <object-name> was not created.</code></pre> @@ -4316,7 +4388,7 @@ characters of HBase options, exceeding the length limit that Trafodion supports. </div> </div> <div class="sect2"> -<h3 id="SQL-1204">3.111. SQL 1204</h3> +<h3 id="SQL-1204">3.114. SQL 1204</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Unsupported Hive datatype <Hive-datatype>.</code></pre> @@ -4338,7 +4410,7 @@ that Trafodion does not support.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1214">3.112. SQL 1214</h3> +<h3 id="SQL-1214">3.115. SQL 1214</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Error <Hive-exception-info> encountered when executing HiveQL statement <Hive-statement>.</code></pre> @@ -4362,7 +4434,7 @@ and Hive detected errors in that statement.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1215">3.113. SQL 1215</h3> +<h3 id="SQL-1215">3.116. SQL 1215</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">An error occurred while determining host, port, or file name for HDFS URI <HDFS-URI>. Cause: <diagnostics>.</code></pre> @@ -4387,7 +4459,25 @@ about that object.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1222">3.114. SQL 1222</h3> +<h3 id="SQL-1220">3.117. SQL 1220</h3> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">Code must contain two non-blank characters.</code></pre> +</div> +</div> +<div class="paragraph"> +<p><strong>Cause:</strong> You attempted to create a component privilege but you specified a component code that is not two non-blank characters.</p> +</div> +<div class="paragraph"> +<p><strong>Effect:</strong> The operation fails.</p> +</div> +<div class="paragraph"> +<p><strong>Recovery:</strong> Correct the statement and resubmit.</p> +</div> +<div style="page-break-after: always;"></div> +</div> +<div class="sect2"> +<h3 id="SQL-1222">3.118. SQL 1222</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Command not supported when authorization is not enabled.</code></pre> @@ -4405,7 +4495,7 @@ is not enabled on this Trafodion instance.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1223">3.115. SQL 1223</h3> +<h3 id="SQL-1223">3.119. SQL 1223</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Grant to self or DB__ROOT is not allowed.</code></pre> @@ -4423,10 +4513,10 @@ is not enabled on this Trafodion instance.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1227">3.116. SQL 1227</h3> +<h3 id="SQL-1227">3.120. SQL 1227</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">Cannot unregister user. User <user-name> has been granted privileges on <object-name>.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">Cannot unregister user. User <user-name> has been granted privileges on <object-name>.</code></pre> </div> </div> <div class="paragraph"> @@ -4446,10 +4536,10 @@ is not enabled on this Trafodion instance.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1228">3.117. SQL 1228</h3> +<h3 id="SQL-1228">3.121. SQL 1228</h3> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">Cannot drop role. Role <role-name> has been granted privileges on <object-name>.</code></pre> +<pre class="CodeRay highlight"><code data-lang="text">Cannot drop role. Role <role-name> has been granted privileges on <object-name>.</code></pre> </div> </div> <div class="paragraph"> @@ -4472,7 +4562,7 @@ Then REVOKE those privileges, and resubmit the DROP ROLE statement.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1230">3.118. SQL 1230</h3> +<h3 id="SQL-1230">3.122. SQL 1230</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Object owner must be the schema owner in private schemas.</code></pre> @@ -4492,7 +4582,7 @@ to match the owner of the schema.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1231">3.119. SQL 1231</h3> +<h3 id="SQL-1231">3.123. SQL 1231</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">User-defined routine <procedure-name> could not be created.</code></pre> @@ -4513,7 +4603,7 @@ this message and reissue the CREATE PROCEDURE statement.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1234">3.120. SQL 1234</h3> +<h3 id="SQL-1234">3.124. SQL 1234</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Authorization needs to be reinitialized due to missing or corrupted privilege manager metadata. To reinitialize, do 'initialize authorization, drop' followed by 'initialize authorization'. This deletes and recreates privilege manager metadata. Trafodion metadata is not affected.</code></pre> @@ -4531,7 +4621,7 @@ this message and reissue the CREATE PROCEDURE statement.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1240">3.121. SQL 1240</h3> +<h3 id="SQL-1240">3.125. SQL 1240</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">The character set for a PARTITION KEY column must be ISO88591.</code></pre> @@ -4549,7 +4639,7 @@ ISO88591 as a partition key.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1243">3.122. SQL 1243</h3> +<h3 id="SQL-1243">3.126. SQL 1243</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">The hexadecimal form of string literals is not allowed in this context.</code></pre> @@ -4568,7 +4658,7 @@ statement, which is not allowed.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1251">3.123. SQL 1251</h3> +<h3 id="SQL-1251">3.127. SQL 1251</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">The extra insignificant digits of default value <value> are truncated to match the scale of the data type of column <column-name>.</code></pre> @@ -4594,7 +4684,7 @@ extra digits to the right are discarded.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1254">3.124. SQL 1254</h3> +<h3 id="SQL-1254">3.128. SQL 1254</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Duplicate unique constraints are not allowed with same set of columns.</code></pre> @@ -4616,7 +4706,7 @@ set of columns.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1255">3.125. SQL 1255</h3> +<h3 id="SQL-1255">3.129. SQL 1255</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Constraint <constraint-name> is the clustering key constraint for table <table-name> and cannot be dropped.</code></pre> @@ -4642,7 +4732,7 @@ clustering key.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1256">3.126. SQL 1256</h3> +<h3 id="SQL-1256">3.130. SQL 1256</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">PRIMARY KEY constraint cannot be added since table <table-name> already has a user specified clustering key.</code></pre> @@ -4665,7 +4755,7 @@ its clustering key.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1260">3.127. SQL 1260</h3> +<h3 id="SQL-1260">3.131. SQL 1260</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Debugging of UDRs is only allowed for the DB__ROOT user. Connect as DB__ROOT, preferably using the sqlci tool, and try again.</code></pre> @@ -4682,7 +4772,7 @@ its clustering key.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1264">3.128. SQL 1264</h3> +<h3 id="SQL-1264">3.132. SQL 1264</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Duplicate privileges are not allowed in a GRANT or REVOKE statement.</code></pre> @@ -4702,7 +4792,7 @@ privilege or a list of distinct privileges.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1266">3.129. SQL 1266</h3> +<h3 id="SQL-1266">3.133. SQL 1266</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Only EXECUTE privilege is supported for a procedure or routine.</code></pre> @@ -4721,7 +4811,7 @@ for the procedure or routine.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1267">3.130. SQL 1267</h3> +<h3 id="SQL-1267">3.134. SQL 1267</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text"><privilege-type> privilege is incompatible with this object type.</code></pre> @@ -4744,7 +4834,7 @@ for the object type.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1268">3.131. SQL 1268</h3> +<h3 id="SQL-1268">3.135. SQL 1268</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Duplicate columns are not allowed in a GRANT or REVOKE statement.</code></pre> @@ -4764,7 +4854,7 @@ column name or a list of distinct column names.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1269">3.132. SQL 1269</h3> +<h3 id="SQL-1269">3.136. SQL 1269</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Column name <column-name> is reserved for internal system usage. It cannot be specified as a user column.</code></pre> @@ -4786,7 +4876,7 @@ you attempted to create a table with a column named SYSKEY.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1276">3.133. SQL 1276</h3> +<h3 id="SQL-1276">3.137. SQL 1276</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Unable to select partition <partition-number> from table <table-name>.</code></pre> @@ -4811,7 +4901,7 @@ table in question is not salted or the table name given refers to a view.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1279">3.134. SQL 1279</h3> +<h3 id="SQL-1279">3.138. SQL 1279</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">A volatile DDL statement cannot be used on regular objects.</code></pre> @@ -4829,7 +4919,7 @@ may have specified DROP VOLATILE TABLE on a table that is not volatile.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1280">3.135. SQL 1280</h3> +<h3 id="SQL-1280">3.139. SQL 1280</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">A regular DDL statement cannot be used on volatile objects.</code></pre> @@ -4848,7 +4938,7 @@ on a volatile table, for example, is not presently supported.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1282">3.136. SQL 1282</h3> +<h3 id="SQL-1282">3.140. SQL 1282</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">A LOB column cannot be specified in a volatile table.</code></pre> @@ -4868,7 +4958,7 @@ mapping is turned off when CQD TRAF_BLOB_AS_VARCHAR and/or CQD TRAF_CLOB_AS_VARC </div> </div> <div class="sect2"> -<h3 id="SQL-1283">3.137. SQL 1283</h3> +<h3 id="SQL-1283">3.141. SQL 1283</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">The specified constraint or file option is not supported on a volatile table.</code></pre> @@ -4887,7 +4977,7 @@ on volatile tables. For example, unique constraints are not supported on volatil <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1289">3.138. SQL 1289</h3> +<h3 id="SQL-1289">3.142. SQL 1289</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">The use of ALTER on reserved schemas and metadata schemas is not permitted.</code></pre> @@ -4905,7 +4995,7 @@ permitted.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1298">3.139. SQL 1298</h3> +<h3 id="SQL-1298">3.143. SQL 1298</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Schema <schema-name> could not be altered. <reason></code></pre> @@ -4931,7 +5021,7 @@ use CLEANUP on certain objects in the schema, then resubmit the ALTER SCHEMA sta <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1313">3.140. SQL 1313</h3> +<h3 id="SQL-1313">3.144. SQL 1313</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">The referential integrity constraint <constraint-name> has been created with the NOT ENFORCED attribute and will not be enforced during INSERT, UPDATE, OR DELETE statements.</code></pre> @@ -4952,7 +5042,7 @@ used when specifying a constraint for documentation purposes only.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1323">3.141. SQL 1323</h3> +<h3 id="SQL-1323">3.145. SQL 1323</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Unable to grant privileges while creating <object-name>.</code></pre> @@ -4974,7 +5064,7 @@ is usually accompanied by other error messages that give details on the cause.</ <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1330">3.142. SQL 1330</h3> +<h3 id="SQL-1330">3.146. SQL 1330</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Cannot revoke role <role-name> from authorization ID <user-name>. Role has been granted to another authorization ID.</code></pre> @@ -4998,7 +5088,7 @@ the user had granted that role to yet another user.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1331">3.143. SQL 1331</h3> +<h3 id="SQL-1331">3.147. SQL 1331</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">User <directory-service-user-name> does not exist in the directory service.</code></pre> @@ -5020,7 +5110,7 @@ does not exist in the directory service.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1332">3.144. SQL 1332</h3> +<h3 id="SQL-1332">3.148. SQL 1332</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Error while communicating with the directory service.</code></pre> @@ -5037,7 +5127,7 @@ does not exist in the directory service.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1333">3.145. SQL 1333</h3> +<h3 id="SQL-1333">3.149. SQL 1333</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">User <user-name> does not exist.</code></pre> @@ -5058,7 +5148,7 @@ does not exist in the directory service.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1334">3.146. SQL 1334</h3> +<h3 id="SQL-1334">3.150. SQL 1334</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">User or role <user-or-role-name> already exists.</code></pre> @@ -5078,7 +5168,7 @@ does not exist in the directory service.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1335">3.147. SQL 1335</h3> +<h3 id="SQL-1335">3.151. SQL 1335</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Directory service user <directory-service-user-name> already defined in the database.</code></pre> @@ -5101,7 +5191,7 @@ already is defined in the Trafodion instance.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1337">3.148. SQL 1337</h3> +<h3 id="SQL-1337">3.152. SQL 1337</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text"><user-name> is a reserved authorization identifier.</code></pre> @@ -5123,7 +5213,7 @@ UNREGISTER "PUBLIC" will fail with this error.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1338">3.149. SQL 1338</h3> +<h3 id="SQL-1338">3.153. SQL 1338</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Role <role-name> is not defined in the database.</code></pre> @@ -5145,7 +5235,7 @@ does not exist in the database.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1339">3.150. SQL 1339</h3> +<h3 id="SQL-1339">3.154. SQL 1339</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text"><role-name> is not a grantable role.</code></pre> @@ -5165,7 +5255,7 @@ does not exist in the database.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1340">3.151. SQL 1340</h3> +<h3 id="SQL-1340">3.155. SQL 1340</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text"><user-name> is not a user.</code></pre> @@ -5187,7 +5277,7 @@ a user name. For example, GET PRIVILEGES FOR USER "PUBLIC" will generate this er <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1347">3.152. SQL 1347</h3> +<h3 id="SQL-1347">3.156. SQL 1347</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Cannot unregister user. User owns one or more roles.</code></pre> @@ -5205,7 +5295,7 @@ or more roles.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1348">3.153. SQL 1348</h3> +<h3 id="SQL-1348">3.157. SQL 1348</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Cannot drop role. Role is granted to one or more users.</code></pre> @@ -5224,7 +5314,7 @@ drop is granted to one or more users.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1349">3.154. SQL 1349</h3> +<h3 id="SQL-1349">3.158. SQL 1349</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Cannot unregister user. User granted one or more roles.</code></pre> @@ -5242,7 +5332,7 @@ or more roles.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1351">3.155. SQL 1351</h3> +<h3 id="SQL-1351">3.159. SQL 1351</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Role <role-name> appears multiple times in list.</code></pre> @@ -5264,7 +5354,7 @@ the given role name appears more than once in the list.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1352">3.156. SQL 1352</h3> +<h3 id="SQL-1352">3.160. SQL 1352</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">User <user-name> appears multiple times in list.</code></pre> @@ -5286,7 +5376,7 @@ the given user name appears more than once in the list.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1355">3.157. SQL 1355</h3> +<h3 id="SQL-1355">3.161. SQL 1355</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Granting a role to PUBLIC or _SYSTEM is not allowed.</code></pre> @@ -5303,7 +5393,7 @@ the given user name appears more than once in the list.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1356">3.158. SQL 1356</h3> +<h3 id="SQL-1356">3.162. SQL 1356</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Cannot create the component privilege specified. Component privilege code <privilege-code> for the component already exists.</code></pre> @@ -5325,7 +5415,7 @@ but the privilege code you specified is already defined.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1357">3.159. SQL 1357</h3> +<h3 id="SQL-1357">3.163. SQL 1357</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Cannot create the component privilege specified. Component privilege name <privilege-name> for the component already exists.</code></pre> @@ -5346,7 +5436,7 @@ but the privilege name you specified is already defined.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1364">3.160. SQL 1364</h3> +<h3 id="SQL-1364">3.164. SQL 1364</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Cannot revoke role <role-name>. Object <object-name-1> depends on privileges on object <object-name-2>.</code></pre> @@ -5373,7 +5463,7 @@ an object not owned by the user, but accessible to the user through the role.</p <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1366">3.161. SQL 1366</h3> +<h3 id="SQL-1366">3.165. SQL 1366</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Request failed. One or more dependent procedures exist.</code></pre> @@ -5391,7 +5481,7 @@ that references this library.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1370">3.162. SQL 1370</h3> +<h3 id="SQL-1370">3.166. SQL 1370</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">The authorization name "<authorization-name>" contains one or more invalid characters. A valid name can only contain these characters: [a-zA-Z_0-9-@./]</code></pre> @@ -5413,7 +5503,7 @@ are not permitted.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1382">3.163. SQL 1382</h3> +<h3 id="SQL-1382">3.167. SQL 1382</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">JAR or DLL file <file-name> not found.</code></pre> @@ -5433,7 +5523,7 @@ are not permitted.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1388">3.164. SQL 1388</h3> +<h3 id="SQL-1388">3.168. SQL 1388</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Object <hive-object-name> does not exist in hive metadata.</code></pre> @@ -5455,7 +5545,7 @@ is not defined in the Hive metadata.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1389">3.165. SQL 1389</h3> +<h3 id="SQL-1389">3.169. SQL 1389</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Object <object-name> does not exist in Trafodion.</code></pre> @@ -5476,7 +5566,7 @@ exist in the Trafodion database.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1390">3.166. SQL 1390</h3> +<h3 id="SQL-1390">3.170. SQL 1390</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Object <object-name> already exists in Trafodion.</code></pre> @@ -5498,7 +5588,7 @@ exists in the Trafodion database.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1391">3.167. SQL 1391</h3> +<h3 id="SQL-1391">3.171. SQL 1391</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text"><object-name> is a <object-kind> object and cannot be updated.</code></pre> @@ -5522,7 +5612,7 @@ where that is not allowed.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1392">3.168. SQL 1392</h3> +<h3 id="SQL-1392">3.172. SQL 1392</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Trafodion is already initialized on this system. No action is needed.</code></pre> @@ -5542,7 +5632,7 @@ destroying your old instance destroys all data in the instance.</p> <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1393">3.169. SQL 1393</h3> +<h3 id="SQL-1393">3.173. SQL 1393</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Trafodion is not initialized on this system. Do 'initialize trafodion' to initialize it.</code></pre> @@ -5559,7 +5649,7 @@ destroying your old instance destroys all data in the instance.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1394">3.170. SQL 1394</h3> +<h3 id="SQL-1394">3.174. SQL 1394</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Trafodion needs to be reinitialized on this system due to missing or corrupted metadata objects. Do 'initialize trafodion, drop' followed by 'initialize trafodion' to reinitialize Trafodion. This will delete all metadata and user objects from the Trafodion database and recreate metadata.</code></pre> @@ -5581,7 +5671,7 @@ If there is no need to keep data from the instance, you can do INITIALIZE TRAFOD <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1395">3.171. SQL 1395</h3> +<h3 id="SQL-1395">3.175. SQL 1395</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Trafodion needs to be upgraded on this system due to metadata version mismatch. Do 'initialize trafodion, upgrade' to upgrade metadata. Or do 'initialize trafodion, drop' followed by 'initialize trafodion'. Be aware that the second option will delete all metadata and user objects from Trafodion database.</code></pre> @@ -5600,7 +5690,7 @@ releases serially and do a metadata upgrade on each. If you do not care about ke </div> </div> <div class="sect2"> -<h3 id="SQL-1396">3.172. SQL 1396</h3> +<h3 id="SQL-1396">3.176. SQL 1396</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Trafodion needs to be reinitialized on this system due to data format version mismatch.</code></pre> @@ -5619,7 +5709,7 @@ data format has never yet changed in Trafodion, so this error should never be se <div style="page-break-after: always;"></div> </div> <div class="sect2"> -<h3 id="SQL-1397">3.173. SQL 1397</h3> +<h3 id="SQL-1397">3.177. SQL 1397</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">Software version of objects being used is different than the version of software running on the system. Make sure that objects being used are built with the same version as that running on the system. Version of Trafodion software is determined by file sqenvcom.sh.</code></pre> @@ -5640,7 +5730,7 @@ If this is not a development environment, contact the Trafodion dlist.</p> </div> </div> <div class="sect2"> -<h3 id="SQL-1398">3.174. SQL 1398</h3> +<h3 id="SQL-1398">3.178. SQL 1398</h3> <div class="listingblock"> <div class="content"> <pre class="CodeRay
<TRUNCATED>
