You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by su...@apache.org on 2016/10/11 18:23:36 UTC
[16/24] incubator-trafodion-site git commit: Second attempt to get
Dave's changes in
http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/274a1883/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 2ef560a..2cb6d0b 100644
--- a/docs/2.1.0/messages_guide/index.html
+++ b/docs/2.1.0/messages_guide/index.html
@@ -1045,156 +1045,340 @@ table.CodeRay td.code>pre{padding:0}
<li><a href="#SQL-3414">5.219. SQL 3414</a></li>
</ul>
</li>
-<li><a href="#optimizer-messages">6. Optimizer Messages (6000 through 6999)</a>
+<li><a href="#binder-messages">6. Binder Messages (4000 through 4999)</a>
<ul class="sectlevel2">
-<li><a href="#SQL-6001">6.1. SQL 6001</a></li>
-<li><a href="#SQL-6002">6.2. SQL 6002</a></li>
-<li><a href="#SQL-6003">6.3. SQL 6003</a></li>
-<li><a href="#SQL-6007">6.4. SQL 6007</a></li>
-<li><a href="#SQL-6008">6.5. SQL 6008</a></li>
+<li><a href="#SQL-4000">6.1. SQL 4000</a></li>
+<li><a href="#SQL-4001">6.2. SQL 4001</a></li>
+<li><a href="#SQL-4002">6.3. SQL 4002</a></li>
+<li><a href="#SQL-4003">6.4. SQL 4003</a></li>
+<li><a href="#SQL-4004">6.5. SQL 4004</a></li>
+<li><a href="#SQL-4005">6.6. SQL 4005</a></li>
+<li><a href="#SQL-4006">6.7. SQL 4006</a></li>
+<li><a href="#SQL-4007">6.8. SQL 4007</a></li>
+<li><a href="#SQL-4008">6.9. SQL 4008</a></li>
+<li><a href="#SQL-4009">6.10. SQL 4009</a></li>
+<li><a href="#SQL-4010">6.11. SQL 4010</a></li>
+<li><a href="#SQL-4011">6.12. SQL 4011</a></li>
+<li><a href="#SQL-4012">6.13. SQL 4012</a></li>
+<li><a href="#SQL-4013">6.14. SQL 4013</a></li>
+<li><a href="#SQL-4014">6.15. SQL 4014</a></li>
+<li><a href="#SQL-4015">6.16. SQL 4015</a></li>
+<li><a href="#SQL-4016">6.17. SQL 4016</a></li>
+<li><a href="#SQL-4017">6.18. SQL 4017</a></li>
+<li><a href="#SQL-4019">6.19. SQL 4019</a></li>
+<li><a href="#SQL-4020">6.20. SQL 4020</a></li>
+<li><a href="#SQL-4021">6.21. SQL 4021</a></li>
+<li><a href="#SQL-4022">6.22. SQL 4022</a></li>
+<li><a href="#SQL-4023">6.23. SQL 4023</a></li>
+<li><a href="#SQL-4024">6.24. SQL 4024</a></li>
+<li><a href="#SQL-4025">6.25. SQL 4025</a></li>
+<li><a href="#SQL-4026">6.26. SQL 4026</a></li>
+<li><a href="#SQL-4027">6.27. SQL 4027</a></li>
+<li><a href="#SQL-4028">6.28. SQL 4028</a></li>
+<li><a href="#SQL-4030">6.29. SQL 4030</a></li>
+<li><a href="#SQL-4031">6.30. SQL 4031</a></li>
+<li><a href="#SQL-4032">6.31. SQL 4032</a></li>
+<li><a href="#SQL-4033">6.32. SQL 4033</a></li>
+<li><a href="#SQL-4034">6.33. SQL 4034</a></li>
+<li><a href="#SQL-4035">6.34. SQL 4035</a></li>
+<li><a href="#SQL-4036-">6.35. SQL 4036</a></li>
+<li><a href="#SQL-4037">6.36. SQL 4037</a></li>
+<li><a href="#SQL-4038">6.37. SQL 4038</a></li>
+<li><a href="#SQL-4039">6.38. SQL 4039</a></li>
+<li><a href="#SQL-4040">6.39. SQL 4040</a></li>
+<li><a href="#SQL-4041">6.40. SQL 4041</a></li>
+<li><a href="#SQL-4042">6.41. SQL 4042</a></li>
+<li><a href="#SQL-4043">6.42. SQL 4043</a></li>
+<li><a href="#SQL-4044">6.43. SQL 4044</a></li>
+<li><a href="#SQL-4045">6.44. SQL 4045</a></li>
+<li><a href="#SQL-4046">6.45. SQL 4046</a></li>
+<li><a href="#SQL-4047">6.46. SQL 4047</a></li>
+<li><a href="#SQL-4048">6.47. SQL 4048</a></li>
+<li><a href="#SQL-4049">6.48. SQL 4049</a></li>
+<li><a href="#SQL-4050">6.49. SQL 4050</a></li>
+<li><a href="#SQL-4051">6.50. SQL 4051</a></li>
+<li><a href="#SQL-4052">6.51. SQL 4052</a></li>
+<li><a href="#SQL-4053">6.52. SQL 4053</a></li>
+<li><a href="#SQL-4055">6.53. SQL 4055</a></li>
+<li><a href="#SQL-4056">6.54. SQL 4056</a></li>
+<li><a href="#SQL-4057">6.55. SQL 4057</a></li>
+<li><a href="#SQL-4059">6.56. SQL 4059</a></li>
+<li><a href="#SQL-4060">6.57. SQL 4060</a></li>
+<li><a href="#SQL-4061">6.58. SQL 4061</a></li>
+<li><a href="#SQL-4062">6.59. SQL 4062</a></li>
+<li><a href="#SQL-4063">6.60. SQL 4063</a></li>
+<li><a href="#SQL-4064">6.61. SQL 4064</a></li>
+<li><a href="#SQL-4065">6.62. SQL 4065</a></li>
+<li><a href="#SQL-4066">6.63. SQL 4066</a></li>
+<li><a href="#SQL-4067">6.64. SQL 4067</a></li>
+<li><a href="#SQL-4068">6.65. SQL 4068</a></li>
+<li><a href="#SQL-4069">6.66. SQL 4069</a></li>
+<li><a href="#SQL-4070">6.67. SQL 4070</a></li>
+<li><a href="#SQL-4071">6.68. SQL 4071</a></li>
+<li><a href="#SQL-4072">6.69. SQL 4072</a></li>
+<li><a href="#SQL-4073">6.70. SQL 4073</a></li>
+<li><a href="#SQL-4074">6.71. SQL 4074</a></li>
+<li><a href="#SQL-4075">6.72. SQL 4075</a></li>
+<li><a href="#SQL-4076">6.73. SQL 4076</a></li>
+<li><a href="#SQL-4077">6.74. SQL 4077</a></li>
+<li><a href="#SQL-4078">6.75. SQL 4078</a></li>
+<li><a href="#SQL-4079">6.76. SQL 4079</a></li>
+<li><a href="#SQL-4082">6.77. SQL 4082</a></li>
+<li><a href="#SQL-4085">6.78. SQL 4085</a></li>
+<li><a href="#SQL-4086">6.79. SQL 4086</a></li>
+<li><a href="#SQL-4087">6.80. SQL 4087</a></li>
+<li><a href="#SQL-4088">6.81. SQL 4088</a></li>
+<li><a href="#SQL-4089">6.82. SQL 4089</a></li>
+<li><a href="#SQL-4093">6.83. SQL 4093</a></li>
+<li><a href="#SQL-4094">6.84. SQL 4094</a></li>
+<li><a href="#SQL-4095">6.85. SQL 4095</a></li>
+<li><a href="#SQL-4096">6.86. SQL 4096</a></li>
+<li><a href="#SQL-4097">6.87. SQL 4097</a></li>
+<li><a href="#SQL-4098">6.88. SQL 4098</a></li>
+<li><a href="#SQL-4099">6.89. SQL 4099</a></li>
+<li><a href="#SQL-4100">6.90. SQL 4100</a></li>
+<li><a href="#SQL-4101">6.91. SQL 4101</a></li>
+<li><a href="#SQL-4102">6.92. SQL 4102</a></li>
+<li><a href="#SQL-4104">6.93. SQL 4104</a></li>
+<li><a href="#SQL-4105">6.94. SQL 4105</a></li>
+<li><a href="#SQL-4106">6.95. SQL 4106</a></li>
+<li><a href="#SQL-4107">6.96. SQL 4107</a></li>
+<li><a href="#SQL-4108">6.97. SQL 4108</a></li>
+<li><a href="#SQL-4109">6.98. SQL 4109</a></li>
+<li><a href="#SQL-4110">6.99. SQL 4110</a></li>
+<li><a href="#SQL-4111">6.100. SQL 4111</a></li>
+<li><a href="#SQL-4112">6.101. SQL 4112</a></li>
+<li><a href="#SQL-4113">6.102. SQL 4113</a></li>
+<li><a href="#SQL-4114">6.103. SQL 4114</a></li>
+<li><a href="#SQL-4115">6.104. SQL 4115</a></li>
+<li><a href="#SQL-4116">6.105. SQL 4116</a></li>
+<li><a href="#SQL-4117">6.106. SQL 4117</a></li>
+<li><a href="#SQL-4120">6.107. SQL 4120</a></li>
+<li><a href="#SQL-4121">6.108. SQL 4121</a></li>
+<li><a href="#SQL-4122">6.109. SQL 4122</a></li>
+<li><a href="#SQL-4123">6.110. SQL 4123</a></li>
+<li><a href="#SQL-4124">6.111. SQL 4124</a></li>
+<li><a href="#SQL-4125">6.112. SQL 4125</a></li>
+<li><a href="#SQL-4126">6.113. SQL 4126</a></li>
+<li><a href="#SQL-4127">6.114. SQL 4127</a></li>
+<li><a href="#SQL-4128">6.115. SQL 4128</a></li>
+<li><a href="#SQL-4129">6.116. SQL 4129</a></li>
+<li><a href="#SQL-4130">6.117. SQL 4130</a></li>
+<li><a href="#SQL-4133">6.118. SQL 4133</a></li>
+<li><a href="#SQL-4134">6.119. SQL 4134</a></li>
+<li><a href="#SQL-4135">6.120. SQL 4135</a></li>
+<li><a href="#SQL-4136">6.121. SQL 4136</a></li>
+<li><a href="#SQL-4150">6.122. SQL 4150</a></li>
+<li><a href="#SQL-4151">6.123. SQL 4151</a></li>
+<li><a href="#SQL-4152">6.124. SQL 4152</a></li>
+<li><a href="#SQL-4153">6.125. SQL 4153</a></li>
+<li><a href="#SQL-4154">6.126. SQL 4154</a></li>
+<li><a href="#SQL-4156">6.127. SQL 4156</a></li>
+<li><a href="#SQL-4157">6.128. SQL 4157</a></li>
+<li><a href="#SQL-4158">6.129. SQL 4158</a></li>
+<li><a href="#SQL-4159">6.130. SQL 4159</a></li>
+<li><a href="#SQL-4160">6.131. SQL 4160</a></li>
+<li><a href="#SQL-4161">6.132. SQL 4161</a></li>
+<li><a href="#SQL-4162">6.133. SQL 4162</a></li>
+<li><a href="#SQL-4163">6.134. SQL 4163</a></li>
+<li><a href="#SQL-4164">6.135. SQL 4164</a></li>
+<li><a href="#SQL-4165">6.136. SQL 4165</a></li>
+<li><a href="#SQL-4166">6.137. SQL 4166</a></li>
+<li><a href="#SQL-4167">6.138. SQL 4167</a></li>
+<li><a href="#SQL-4168">6.139. SQL 4168</a></li>
+<li><a href="#SQL-4169">6.140. SQL 4169</a></li>
+<li><a href="#SQL-4170">6.141. SQL 4170</a></li>
+<li><a href="#SQL-4171">6.142. SQL 4171</a></li>
+<li><a href="#SQL-4173">6.143. SQL 4173</a></li>
+<li><a href="#SQL-4174">6.144. SQL 4174</a></li>
+<li><a href="#SQL-4175">6.145. SQL 4175</a></li>
+<li><a href="#SQL-4176">6.146. SQL 4176</a></li>
+<li><a href="#SQL-4177">6.147. SQL 4177</a></li>
+<li><a href="#SQL-4178">6.148. SQL 4178</a></li>
+<li><a href="#SQL-4179">6.149. SQL 4179</a></li>
+<li><a href="#SQL-4180">6.150. SQL 4180</a></li>
+<li><a href="#SQL-4183">6.151. SQL 4183</a></li>
+<li><a href="#SQL-4184">6.152. SQL 4184</a></li>
+<li><a href="#SQL-4189">6.153. SQL 4189</a></li>
+<li><a href="#SQL-4200">6.154. SQL 4200</a></li>
+<li><a href="#SQL-4201">6.155. SQL 4201</a></li>
+<li><a href="#SQL-4202">6.156. SQL 4202</a></li>
+<li><a href="#SQL-4203">6.157. SQL 4203</a></li>
+<li><a href="#SQL-4204">6.158. SQL 4204</a></li>
+<li><a href="#SQL-4205">6.159. SQL 4205</a></li>
+<li><a href="#SQL-4206">6.160. SQL 4206</a></li>
+<li><a href="#SQL-4207">6.161. SQL 4207</a></li>
+<li><a href="#SQL-4208">6.162. SQL 4208</a></li>
+<li><a href="#SQL-4209">6.163. SQL 4209</a></li>
+<li><a href="#SQL-4210">6.164. SQL 4210</a></li>
+<li><a href="#SQL-4212">6.165. SQL 4212</a></li>
+<li><a href="#SQL-4213">6.166. SQL 4213</a></li>
+<li><a href="#SQL-4214">6.167. SQL 4214</a></li>
+<li><a href="#SQL-4215">6.168. SQL 4215</a></li>
+<li><a href="#SQL-4216">6.169. SQL 4216</a></li>
+<li><a href="#SQL-4302">6.170. SQL 4302</a></li>
+<li><a href="#SQL-4303">6.171. SQL 4303</a></li>
+<li><a href="#SQL-4304">6.172. SQL 4304</a></li>
+<li><a href="#SQL-4305">6.173. SQL 4305</a></li>
+<li><a href="#SQL-4306">6.174. SQL 4306</a></li>
+<li><a href="#SQL-4307">6.175. SQL 4307</a></li>
+<li><a href="#SQL-4308">6.176. SQL 4308</a></li>
+<li><a href="#SQL-4309">6.177. SQL 4309</a></li>
+<li><a href="#SQL-4310">6.178. SQL 4310</a></li>
+<li><a href="#SQL-4313">6.179. SQL 4313</a></li>
+<li><a href="#SQL-4320">6.180. SQL 4320</a></li>
</ul>
</li>
-<li><a href="#generator-messages">7. Generator Messages (7000 through 7999)</a>
+<li><a href="#optimizer-messages">7. Optimizer Messages (6000 through 6999)</a>
<ul class="sectlevel2">
-<li><a href="#SQL-7001">7.1. SQL 7001</a></li>
-<li><a href="#SQL-7003">7.2. SQL 7003</a></li>
+<li><a href="#SQL-6001">7.1. SQL 6001</a></li>
+<li><a href="#SQL-6002">7.2. SQL 6002</a></li>
+<li><a href="#SQL-6003">7.3. SQL 6003</a></li>
+<li><a href="#SQL-6007">7.4. SQL 6007</a></li>
+<li><a href="#SQL-6008">7.5. SQL 6008</a></li>
</ul>
</li>
-<li><a href="#executor-messages">8. Executor Messages (8000 through 8999)</a>
+<li><a href="#generator-messages">8. Generator Messages (7000 through 7999)</a>
<ul class="sectlevel2">
-<li><a href="#SQL-8006">8.1. SQL 8006</a></li>
-<li><a href="#SQL-8007">8.2. SQL 8007</a></li>
-<li><a href="#SQL-8012">8.3. SQL 8012</a></li>
-<li><a href="#SQL-8016">8.4. SQL 8016</a></li>
-<li><a href="#SQL-8017">8.5. SQL 8017</a></li>
-<li><a href="#SQL-8101">8.6. SQL 8101</a></li>
-<li><a href="#SQL-8102">8.7. SQL 8102</a></li>
-<li><a href="#SQL-8103">8.8. SQL 8103</a></li>
-<li><a href="#SQL-8104">8.9. SQL 8104</a></li>
-<li><a href="#SQL-8105">8.10. SQL 8105</a></li>
-<li><a href="#SQL-8302">8.11. SQL 8302</a></li>
-<li><a href="#SQL-8553">8.12. SQL 8553</a></li>
-<li><a href="#SQL-8573">8.13. SQL 8573</a></li>
-<li><a href="#SQL-8576">8.14. SQL 8576</a></li>
-<li><a href="#SQL-8577">8.15. SQL 8577</a></li>
-<li><a href="#SQL-8578">8.16. SQL 8578</a></li>
-<li><a href="#SQL-8579">8.17. SQL 8579</a></li>
-<li><a href="#SQL-8604">8.18. SQL 8604</a></li>
-<li><a href="#SQL-8605">8.19. SQL 8605</a></li>
-<li><a href="#SQL-8606">8.20. SQL 8606</a></li>
-<li><a href="#SQL-8607">8.21. SQL 8607</a></li>
-<li><a href="#SQL-8608">8.22. SQL 8608</a></li>
-<li><a href="#SQL-8609">8.23. SQL 8609</a></li>
-<li><a href="#SQL-8610">8.24. SQL 8610</a></li>
-<li><a href="#SQL-8612">8.25. SQL 8612</a></li>
-<li><a href="#SQL-8613">8.26. SQL 8613</a></li>
-<li><a href="#SQL-8808">8.27. SQL 8808</a></li>
-<li><a href="#SQL-8809">8.28. SQL 8809</a></li>
-<li><a href="#SQL-8819">8.29. SQL 8819</a></li>
-<li><a href="#SQL-8820">8.30. SQL 8820</a></li>
-<li><a href="#SQL-8821">8.31. SQL 8821</a></li>
-<li><a href="#SQL-8824">8.32. SQL 8824</a></li>
-<li><a href="#SQL-8826">8.33. SQL 8826</a></li>
-<li><a href="#SQL-8827">8.34. SQL 8827</a></li>
-<li><a href="#SQL-8832">8.35. SQL 8832</a></li>
-<li><a href="#SQL-8833">8.36. SQL 8833</a></li>
-<li><a href="#SQL-8834">8.37. SQL 8834</a></li>
-<li><a href="#SQL-8836">8.38. SQL 8836</a></li>
-<li><a href="#SQL-8837">8.39. SQL 8837</a></li>
-<li><a href="#SQL-8840">8.40. SQL 8840</a></li>
-<li><a href="#SQL-8841">8.41. SQL 8841</a></li>
-<li><a href="#SQL-8842">8.42. SQL 8842</a></li>
-<li><a href="#SQL-8846">8.43. SQL 8846</a></li>
-<li><a href="#SQL-8850">8.44. SQL 8850</a></li>
-<li><a href="#SQL-8860">8.45. SQL 8860</a></li>
-<li><a href="#SQL-8861">8.46. SQL 8861</a></li>
-<li><a href="#SQL-8862">8.47. SQL 8862</a></li>
-<li><a href="#SQL-8863">8.48. SQL 8863</a></li>
-<li><a href="#SQL-8864">8.49. SQL 8864</a></li>
-<li><a href="#SQL-8865">8.50. SQL 8865</a></li>
-<li><a href="#SQL-8866">8.51. SQL 8866</a></li>
-<li><a href="#SQL-8867">8.52. SQL 8867</a></li>
-<li><a href="#SQL-8882">8.53. SQL 8882</a></li>
-<li><a href="#SQL-8888">8.54. SQL 8888</a></li>
-<li><a href="#SQL-8890">8.55. SQL 8890</a></li>
-<li><a href="#SQL-8901">8.56. SQL 8901</a></li>
-<li><a href="#SQL-8904">8.57. SQL 8904</a></li>
+<li><a href="#SQL-7001">8.1. SQL 7001</a></li>
+<li><a href="#SQL-7003">8.2. SQL 7003</a></li>
</ul>
</li>
-<li><a href="#update-stats-messages">9. Update Statistics Messages (9200 through 9299)</a>
+<li><a href="#executor-messages">9. Executor Messages (8000 through 8999)</a>
<ul class="sectlevel2">
-<li><a href="#SQL-9200">9.1. SQL 9200</a></li>
-<li><a href="#SQL-9201">9.2. SQL 9201</a></li>
-<li><a href="#SQL-9202">9.3. SQL 9202</a></li>
-<li><a href="#SQL-9203">9.4. SQL 9203</a></li>
-<li><a href="#SQL-9204">9.5. SQL 9204</a></li>
-<li><a href="#SQL-9205">9.6. SQL 9205</a></li>
-<li><a href="#SQL-9206">9.7. SQL 9206</a></li>
-<li><a href="#SQL-9207">9.8. SQL 9207</a></li>
-<li><a href="#SQL-9208">9.9. SQL 9208</a></li>
-<li><a href="#SQL-9209">9.10. SQL 9209</a></li>
-<li><a href="#SQL-9210">9.11. SQL 9210</a></li>
-<li><a href="#SQL-9211">9.12. SQL 9211</a></li>
-<li><a href="#SQL-9212">9.13. SQL 9212</a></li>
-<li><a href="#SQL-9213">9.14. SQL 9213</a></li>
-<li><a href="#SQL-9214">9.15. SQL 9214</a></li>
-<li><a href="#SQL-9215">9.16. SQL 9215</a></li>
-<li><a href="#SQL-9217">9.17. SQL 9217</a></li>
-<li><a href="#SQL-9218">9.18. SQL 9218</a></li>
-<li><a href="#SQL-9219">9.19. SQL 9219</a></li>
-<li><a href="#SQL-9221">9.20. SQL 9221</a></li>
-<li><a href="#SQL-9228">9.21. SQL 9228</a></li>
-<li><a href="#SQL-9232">9.22. SQL 9232</a></li>
-<li><a href="#SQL-9240">9.23. SQL 9240</a></li>
-<li><a href="#SQL-9241">9.24. SQL 9241</a></li>
-<li><a href="#SQL-9242">9.25. SQL 9242</a></li>
-<li><a href="#SQL-9243">9.26. SQL 9243</a></li>
-<li><a href="#SQL-9244">9.27. SQL 9244</a></li>
-<li><a href="#SQL-9245">9.28. SQL 9245</a></li>
-<li><a href="#SQL-9246">9.29. SQL 9246</a></li>
-<li><a href="#SQL-9247">9.30. SQL 9247</a></li>
-<li><a href="#SQL-9251">9.31. SQL 9251</a></li>
+<li><a href="#SQL-8006">9.1. SQL 8006</a></li>
+<li><a href="#SQL-8007">9.2. SQL 8007</a></li>
+<li><a href="#SQL-8012">9.3. SQL 8012</a></li>
+<li><a href="#SQL-8016">9.4. SQL 8016</a></li>
+<li><a href="#SQL-8017">9.5. SQL 8017</a></li>
+<li><a href="#SQL-8101">9.6. SQL 8101</a></li>
+<li><a href="#SQL-8102">9.7. SQL 8102</a></li>
+<li><a href="#SQL-8103">9.8. SQL 8103</a></li>
+<li><a href="#SQL-8104">9.9. SQL 8104</a></li>
+<li><a href="#SQL-8105">9.10. SQL 8105</a></li>
+<li><a href="#SQL-8302">9.11. SQL 8302</a></li>
+<li><a href="#SQL-8553">9.12. SQL 8553</a></li>
+<li><a href="#SQL-8573">9.13. SQL 8573</a></li>
+<li><a href="#SQL-8576">9.14. SQL 8576</a></li>
+<li><a href="#SQL-8577">9.15. SQL 8577</a></li>
+<li><a href="#SQL-8578">9.16. SQL 8578</a></li>
+<li><a href="#SQL-8579">9.17. SQL 8579</a></li>
+<li><a href="#SQL-8604">9.18. SQL 8604</a></li>
+<li><a href="#SQL-8605">9.19. SQL 8605</a></li>
+<li><a href="#SQL-8606">9.20. SQL 8606</a></li>
+<li><a href="#SQL-8607">9.21. SQL 8607</a></li>
+<li><a href="#SQL-8608">9.22. SQL 8608</a></li>
+<li><a href="#SQL-8609">9.23. SQL 8609</a></li>
+<li><a href="#SQL-8610">9.24. SQL 8610</a></li>
+<li><a href="#SQL-8612">9.25. SQL 8612</a></li>
+<li><a href="#SQL-8613">9.26. SQL 8613</a></li>
+<li><a href="#SQL-8808">9.27. SQL 8808</a></li>
+<li><a href="#SQL-8809">9.28. SQL 8809</a></li>
+<li><a href="#SQL-8819">9.29. SQL 8819</a></li>
+<li><a href="#SQL-8820">9.30. SQL 8820</a></li>
+<li><a href="#SQL-8821">9.31. SQL 8821</a></li>
+<li><a href="#SQL-8824">9.32. SQL 8824</a></li>
+<li><a href="#SQL-8826">9.33. SQL 8826</a></li>
+<li><a href="#SQL-8827">9.34. SQL 8827</a></li>
+<li><a href="#SQL-8832">9.35. SQL 8832</a></li>
+<li><a href="#SQL-8833">9.36. SQL 8833</a></li>
+<li><a href="#SQL-8834">9.37. SQL 8834</a></li>
+<li><a href="#SQL-8836">9.38. SQL 8836</a></li>
+<li><a href="#SQL-8837">9.39. SQL 8837</a></li>
+<li><a href="#SQL-8840">9.40. SQL 8840</a></li>
+<li><a href="#SQL-8841">9.41. SQL 8841</a></li>
+<li><a href="#SQL-8842">9.42. SQL 8842</a></li>
+<li><a href="#SQL-8846">9.43. SQL 8846</a></li>
+<li><a href="#SQL-8850">9.44. SQL 8850</a></li>
+<li><a href="#SQL-8860">9.45. SQL 8860</a></li>
+<li><a href="#SQL-8861">9.46. SQL 8861</a></li>
+<li><a href="#SQL-8862">9.47. SQL 8862</a></li>
+<li><a href="#SQL-8863">9.48. SQL 8863</a></li>
+<li><a href="#SQL-8864">9.49. SQL 8864</a></li>
+<li><a href="#SQL-8865">9.50. SQL 8865</a></li>
+<li><a href="#SQL-8866">9.51. SQL 8866</a></li>
+<li><a href="#SQL-8867">9.52. SQL 8867</a></li>
+<li><a href="#SQL-8882">9.53. SQL 8882</a></li>
+<li><a href="#SQL-8888">9.54. SQL 8888</a></li>
+<li><a href="#SQL-8890">9.55. SQL 8890</a></li>
+<li><a href="#SQL-8901">9.56. SQL 8901</a></li>
+<li><a href="#SQL-8904">9.57. SQL 8904</a></li>
</ul>
</li>
-<li><a href="#sort-messages">10. Sort Messages (10000 through 10049)</a>
+<li><a href="#update-stats-messages">10. Update Statistics Messages (9200 through 9299)</a>
<ul class="sectlevel2">
-<li><a href="#SQL-10007-">10.1. SQL 10007</a></li>
-<li><a href="#SQL-10011-">10.2. SQL 10011</a></li>
-<li><a href="#SQL-10013-">10.3. SQL 10013</a></li>
-<li><a href="#SQL-10014-">10.4. SQL 10014</a></li>
-<li><a href="#SQL-10015-">10.5. SQL 10015</a></li>
-<li><a href="#SQL-10016-">10.6. SQL 10016</a></li>
-<li><a href="#SQL-10017-">10.7. SQL 10017</a></li>
-<li><a href="#SQL-10018-">10.8. SQL 10018</a></li>
-<li><a href="#SQL-10019-">10.9. SQL 10019</a></li>
-<li><a href="#SQL-10020-">10.10. SQL 10020</a></li>
-<li><a href="#SQL-10021-">10.11. SQL 10021</a></li>
-<li><a href="#SQL-10022-">10.12. SQL 10022</a></li>
-<li><a href="#SQL-10023-">10.13. SQL 10023</a></li>
-<li><a href="#SQL-10024-">10.14. SQL 10024</a></li>
-<li><a href="#SQL-10027-">10.15. SQL 10027</a></li>
-<li><a href="#SQL-10028-">10.16. SQL 10028</a></li>
-<li><a href="#SQL-10029-">10.17. SQL 10029</a></li>
-<li><a href="#SQL-10047-">10.18. SQL 10047</a></li>
-<li><a href="#SQL-10048-">10.19. SQL 10048</a></li>
+<li><a href="#SQL-9200">10.1. SQL 9200</a></li>
+<li><a href="#SQL-9201">10.2. SQL 9201</a></li>
+<li><a href="#SQL-9202">10.3. SQL 9202</a></li>
+<li><a href="#SQL-9203">10.4. SQL 9203</a></li>
+<li><a href="#SQL-9204">10.5. SQL 9204</a></li>
+<li><a href="#SQL-9205">10.6. SQL 9205</a></li>
+<li><a href="#SQL-9206">10.7. SQL 9206</a></li>
+<li><a href="#SQL-9207">10.8. SQL 9207</a></li>
+<li><a href="#SQL-9208">10.9. SQL 9208</a></li>
+<li><a href="#SQL-9209">10.10. SQL 9209</a></li>
+<li><a href="#SQL-9210">10.11. SQL 9210</a></li>
+<li><a href="#SQL-9211">10.12. SQL 9211</a></li>
+<li><a href="#SQL-9212">10.13. SQL 9212</a></li>
+<li><a href="#SQL-9213">10.14. SQL 9213</a></li>
+<li><a href="#SQL-9214">10.15. SQL 9214</a></li>
+<li><a href="#SQL-9215">10.16. SQL 9215</a></li>
+<li><a href="#SQL-9217">10.17. SQL 9217</a></li>
+<li><a href="#SQL-9218">10.18. SQL 9218</a></li>
+<li><a href="#SQL-9219">10.19. SQL 9219</a></li>
+<li><a href="#SQL-9221">10.20. SQL 9221</a></li>
+<li><a href="#SQL-9228">10.21. SQL 9228</a></li>
+<li><a href="#SQL-9232">10.22. SQL 9232</a></li>
+<li><a href="#SQL-9240">10.23. SQL 9240</a></li>
+<li><a href="#SQL-9241">10.24. SQL 9241</a></li>
+<li><a href="#SQL-9242">10.25. SQL 9242</a></li>
+<li><a href="#SQL-9243">10.26. SQL 9243</a></li>
+<li><a href="#SQL-9244">10.27. SQL 9244</a></li>
+<li><a href="#SQL-9245">10.28. SQL 9245</a></li>
+<li><a href="#SQL-9246">10.29. SQL 9246</a></li>
+<li><a href="#SQL-9247">10.30. SQL 9247</a></li>
+<li><a href="#SQL-9251">10.31. SQL 9251</a></li>
</ul>
</li>
-<li><a href="#udr-server-and-language-manager-messages">11. UDR Server and Language Manager Messages (11000 through 11399)</a>
+<li><a href="#sort-messages">11. Sort Messages (10000 through 10049)</a>
<ul class="sectlevel2">
-<li><a href="#SQL-11108">11.1. SQL 11108</a></li>
-<li><a href="#SQL-11201">11.2. SQL 11201</a></li>
-<li><a href="#SQL-11202">11.3. SQL 11202</a></li>
-<li><a href="#SQL-11221">11.4. SQL 11221</a></li>
-<li><a href="#SQL-11222">11.5. SQL 11222</a></li>
+<li><a href="#SQL-10007-">11.1. SQL 10007</a></li>
+<li><a href="#SQL-10011-">11.2. SQL 10011</a></li>
+<li><a href="#SQL-10013-">11.3. SQL 10013</a></li>
+<li><a href="#SQL-10014-">11.4. SQL 10014</a></li>
+<li><a href="#SQL-10015-">11.5. SQL 10015</a></li>
+<li><a href="#SQL-10016-">11.6. SQL 10016</a></li>
+<li><a href="#SQL-10017-">11.7. SQL 10017</a></li>
+<li><a href="#SQL-10018-">11.8. SQL 10018</a></li>
+<li><a href="#SQL-10019-">11.9. SQL 10019</a></li>
+<li><a href="#SQL-10020-">11.10. SQL 10020</a></li>
+<li><a href="#SQL-10021-">11.11. SQL 10021</a></li>
+<li><a href="#SQL-10022-">11.12. SQL 10022</a></li>
+<li><a href="#SQL-10023-">11.13. SQL 10023</a></li>
+<li><a href="#SQL-10024-">11.14. SQL 10024</a></li>
+<li><a href="#SQL-10027-">11.15. SQL 10027</a></li>
+<li><a href="#SQL-10028-">11.16. SQL 10028</a></li>
+<li><a href="#SQL-10029-">11.17. SQL 10029</a></li>
+<li><a href="#SQL-10047-">11.18. SQL 10047</a></li>
+<li><a href="#SQL-10048-">11.19. SQL 10048</a></li>
</ul>
</li>
-<li><a href="#sqlstate">12. SQLSTATE</a>
+<li><a href="#udr-server-and-language-manager-messages">12. UDR Server and Language Manager Messages (11000 through 11399)</a>
<ul class="sectlevel2">
-<li><a href="#sqlstate-and-sqlcode-considerations">12.1. SQLSTATE and SQLCODE Considerations</a></li>
-<li><a href="#sqlstate-values">12.2. SQLSTATE Values</a></li>
+<li><a href="#SQL-11108">12.1. SQL 11108</a></li>
+<li><a href="#SQL-11201">12.2. SQL 11201</a></li>
+<li><a href="#SQL-11202">12.3. SQL 11202</a></li>
+<li><a href="#SQL-11221">12.4. SQL 11221</a></li>
+<li><a href="#SQL-11222">12.5. SQL 11222</a></li>
</ul>
</li>
-<li><a href="#file-system-errors">13. File-System Errors</a></li>
+<li><a href="#sqlstate">13. SQLSTATE</a>
+<ul class="sectlevel2">
+<li><a href="#sqlstate-and-sqlcode-considerations">13.1. SQLSTATE and SQLCODE Considerations</a></li>
+<li><a href="#sqlstate-values">13.2. SQLSTATE Values</a></li>
+</ul>
+</li>
+<li><a href="#file-system-errors">14. File-System Errors</a></li>
</ul>
</div>
</div>
@@ -11601,10 +11785,3684 @@ DEFAULT for all the tuples in the list.</p>
</div>
</div>
<div class="sect1">
-<h2 id="optimizer-messages">6. Optimizer Messages (6000 through 6999)</h2>
+<h2 id="binder-messages">6. Binder Messages (4000 through 4999)</h2>
+<div class="sectionbody">
+<div class="sect2">
+<h3 id="SQL-4000">6.1. SQL 4000</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Internal error in the query binder.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> An internal error in the SQL compiler.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> None. Contact <a href="mailto:user@trafodion.incubator.apache.org">user@trafodion.incubator.apache.org</a>.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4001">6.2. SQL 4001</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Column <name-1> is not found. Tables in scope: <names>. Default schema: <name-2>.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You referenced column <name-1>, which the Trafodion database
+software could not find. A list of the tables <names> in the scope of the
+column reference and the default schema <name-2> appear.</p>
+</div>
+<div class="paragraph">
+<p>A common reason for this error is that you have used double quotes
+instead of single quotes. For example:</p>
+</div>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">>> SELECT * FROM tb WHERE b > "b";</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p>result in this error:</p>
+</div>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">*** ERROR[4001] Column "b" is not found. Tables in scope: CAT.SCH.TB. Default schema: CAT.SCH.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p>In this example, the user specified double quotes, which indicate a
+delimited identifier, rather than single quotes, which indicate an alpha
+literal.</p>
+</div>
+<div class="paragraph">
+<p>The user probably intended:</p>
+</div>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">>> SELECT * FROM tb WHERE b > 'b' ; -- alpha literal or
+>> SELECT * FROM tb WHERE b > "v" ; -- table tb (a int, b char, "v" char)</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax so that the table and column can be
+found, and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4002">6.3. SQL 4002</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Column <name-1> is not found. Table <name-2> not exposed. Tables in scope: <names>. Default schema: <name-3>.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You referenced a qualified column <name-1>, which the Trafodion database
+software could not find. Table <name-2> is not exposed. A list of the tables <names>
+in the scope of the column reference and the default schema
+<name-3> appear.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax so that the table and column can be
+found, and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4003">6.4. SQL 4003</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Column <name-1> is not a column in table <name-2>, or, after a NATURAL JOIN or JOIN USING, is no longer allowed to be specified with a table correlation name.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You either attempted to select column <name-1>, which does not
+exist, or referenced a column that is included in a NATURAL JOIN or JOIN
+USING and is now a common column. If a column is part of a JOIN
+operation, you no longer qualify its name with its original table
+<name-2>.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit. If the column is part of a
+JOIN, remove the table qualifier and use only the column name.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4004">6.5. SQL 4004</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Column name <name-1> is ambiguous. Tables in scope: <names>. Default schema: <name-2>.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You referenced column <name-1>, whose parent table is ambiguous.
+The table <names> or tables in the scope of the column reference and
+default schema <name-2> appear.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax so that the table’s parent table is
+clear, and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4005">6.6. SQL 4005</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Column reference <name> must be a grouping column or be specified within an aggregate.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You referenced column <name>, which is not a grouping column or is not specified within an aggregate, which is not supported.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the column reference and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4006">6.7. SQL 4006</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Within an aggregate, all column references must come from the same scope.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You referred to columns that do not come from the same scope.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the column references and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4007">6.8. SQL 4007</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The select list index <value-1> is out of range. It must be between 1 and the number of select expressions, which in this case is <value-2>.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified an index <value-1> that is out of the range of
+between 1 and the <value-2> of SELECT expressions.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the index and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4008">6.9. SQL 4008</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">A sub query is not allowed inside an aggregate function.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> This error can occur only if support for subqueries inside
+aggregate functions has been turned off (e.g., via CQD UDF_SUBQ_IN_AGGS_AND_GBYS 'OFF').
+(Note: By default, this support is presently turned on.)
+You specified a sub query within an aggregate function, which is
+not supported when this support has been turned off.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4009">6.10. SQL 4009</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">An aggregate is not allowed inside an aggregate function.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified an aggregate inside an aggregate function.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4010">6.11. SQL 4010</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">There are no columns with the correlation name <table-name>.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified columns with the <table-name> qualifier, which
+does not exist or is not in scope at this point in the query.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4011">6.12. SQL 4011</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Reference made to column <name> via star (*) is ambiguous.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p>Where <name> is the name of the column.</p>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You referred to column <name> using the <code>SELECT <strong></code> or <code>SELECT TBL.</strong></code>
+reference, and the Trafodion database software could not locate the column
+because the reference is ambiguous.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4012">6.13. SQL 4012</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Column reference <name> must be a grouping column or be specified within an aggregate. On this grouped table a star reference is not allowed.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You implicitly referred to column <name> with a SELECT * or SELECT TBL.*
+reference. Column <name> must be a grouping column or be specified
+within an aggregate.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4013">6.14. SQL 4013</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Column <name> is a system column and cannot be updated or inserted into.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You attempted to update or insert into a system column
+<name>, which is not supported.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax to refer to a non-system column.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4014">6.15. SQL 4014</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The operands of an INTERSECT or EXCEPT must be of equal degree.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You created an INTERSECT or EXCEPT with operands of unequal degree. They
+must be equal.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4015">6.16. SQL 4015</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Aggregate functions are placed incorrectly: <name>.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You used aggregate function <name> on an ungrouped table. For
+example, you used an aggregate function in a predicate (WHERE or
+HAVING), but the aggregated columns come from the local scope instead of
+an outer scope.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4016">6.17. SQL 4016</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The number of derived columns (<value-1>) must equal the degree of the derived table (<value-2>).</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified a statement in which the number of derived
+columns (<value-1>) does not equal the degree of the derived table
+(<value-2>). They must be equal.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4017">6.18. SQL 4017</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Derived column name <name> was specified more than once.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified column <name> more than once.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4019">6.19. SQL 4019</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The select list of a sub query in a select list must be scalar (degree of one).</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> This error can only appear if support for mulit-degree subqueries has been turned
+off (e.g. via CQD ALLOW_MULTIDEGREE_SUBQ_IN_SELECTLIST 'OFF'). (Note: By default, this
+support is turned on.) You specified a sub query of degree greater than one inside a select list,
+and the support for this was turned off.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4020">6.20. SQL 4020</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Arithmetic operations on row value constructors are not allowed.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You attempted to perform an arithmetic operation on row value
+constructors, which is not supported.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4021">6.21. SQL 4021</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The select list contains a non-grouping non-aggregated column, <name>.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified a select list that contains a non-grouping,
+non-aggregated column <name>, which is not supported.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4022">6.22. SQL 4022</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Target column <name> was specified more than once.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified column <name> more than once.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4023">6.23. SQL 4023</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The degree of each row value constructor (<value>) must equal the degree of the target table column list (<value>).</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified a statement, such as INSERT, in which a <row-value> constructor does not equal the degree of the target table column
+list. For example:</p>
+</div>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">INSERT INTO table (acol, bcol) VALUES (1, 2, 3);</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p>is wrong because the number of columns does not match the number of
+values.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4024">6.24. SQL 4024</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Column <name> has no default value, so it must be explicitly specified in the insert column list.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You attempted to insert column <name> into a table, and the
+column has no default value. For example:</p>
+</div>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">INSERT INTO table (acol, bcol, ccol) VALUES (1, 2);</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p>is wrong if ccol does not have a default value and you did not specify
+its value. The column list is optional, but if you use it, you must
+explicitly specify values for columns that do not have default values.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4025">6.25. SQL 4025</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Error while preparing constraint <name> on table <table-name>.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p>Where <table-name> is the name of the table.</p>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> Trafodion received an error while
+preparing constraint <name> on <table-name>. See accompanying error
+messages.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4026">6.26. SQL 4026</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Reading from and inserting into, or updating in, or deleting from the same table, <name>, is not currently supported.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p>Where <name> is the name of the table.</p>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> This error can only occur if support for Halloween updates has been turned off (e.g., via CQD R2_HALLOWEEN_SUPPORT 'OFF'). (Note: By default, support for Halloween updates is turned on.) You attempted to read from and insert, update, or delete within
+the same table <name> but support for this feature has been turned off.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4027">6.27. SQL 4027</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Table or view <name> does not permit insertions.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p>Where <name> is the name of the table.</p>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You attempted to insert into table <name>, which is not
+insertable.</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-4028">6.28. SQL 4028</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Table or view <name> is not updatable.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You attempted to update table <name>, which is not updatable.</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-4030">6.29. SQL 4030</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Column <name> has an invalid combination of datetime fields (internal field number, internal field number, internal field number).</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified column <name>, which is an invalid combination of datetime fields.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4031">6.30. SQL 4031</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Column <name> has an unknown data type, <type>.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified column <name> with an unknown data <type>.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4032">6.31. SQL 4032</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Column <name> has an unknown class, <class>. It is neither a system column nor a user column.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified column <name> with an unknown class.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4033">6.32. SQL 4033</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Column <name> is a primary or clustering key column and cannot be updated.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You attempted to update column <name>, which is a primary or
+clustering key column that cannot be updated.</p>
+</div>
+<div class="paragraph">
+<p>Note: Trafodion does support update of primary or clustering keys in most contexts.
+It does not support this in the BEFORE part of a trigger.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4034">6.33. SQL 4034</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The operation (<data-type> <operation-data-type>) operation is not allowed.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified an operation that is not supported. Sometimes this message is accompanied
+with another that gives more detail.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4035">6.34. SQL 4035</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Type <specification-1> cannot be cast to type <specification-2>.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You attempted to cast type <specification-1> to another type
+<specification-2> that is not valid.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4036-">6.35. SQL 4036</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The source field of the EXTRACT function must be of DateTime or Interval type.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified a source field of the EXTRACT function that is
+not a DATETIME or INTERVAL data type. This message is also given for the
+YEAR, MONTH, DAY, HOUR, MINUTE and SECOND functions.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the source field type and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4037">6.36. SQL 4037</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Field <name> cannot be extracted from a source of type <specification>.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You attempted to extract field <name> from a source whose type
+<specification> does not support this.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4038">6.37. SQL 4038</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The operand of an AVG or SUM function must be numeric or interval.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You attempted to perform an AVG or SUM function with an invalid
+operand. It must be numeric or interval.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4039">6.38. SQL 4039</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Column <name> is of type <specification-1>, incompatible with the value's type, <specification-2>.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified column <name> with type <specification-1>, which
+is incompatible with the type of the value.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4040">6.39. SQL 4040</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The operands of a BETWEEN predicate must be of equal degree.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified operands for a BETWEEN predicate that are not of
+equal degree, which is required.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax so that the operands are of equal degree
+and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4041">6.40. SQL 4041</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Type <specification-1> cannot be compared with type <specification-2>.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You attempted to compare two expressions with type specifications that cannot be
+compared.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4042">6.41. SQL 4042</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The operands of a comparison predicate must be of equal degree.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified a comparison predicate with operands that are not
+of equal degree, which is required.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4043">6.42. SQL 4043</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The operand of function <name> must be character.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified an operand for function <name> that is not a
+character, which is required.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4044">6.43. SQL 4044</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Collation <name-1> does not support the <name-2> predicate or</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p>function.</p>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified collation <name-1>, which does not support the
+predicate or function listed in the message.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4045">6.44. SQL 4045</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The operand of function <name> must be numeric.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified operands for function <name> that are not
+numeric, which is required.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4046">6.45. SQL 4046</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The operands of function <name> must be exact numeric.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified operands of function <name> that are not type
+exact numeric, which is required.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4047">6.46. SQL 4047</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The operands of function <name> must have a scale of 0.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified operands of function <name> that do not have a
+scale of zero (0), which is required.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4048">6.47. SQL 4048</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The third operand of a ternary comparison operator must be of type BOOLEAN, not <type>.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified the third operand of a ternary comparison
+argument with an invalid <type>. The type must be boolean.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4049">6.48. SQL 4049</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">A CASE expression cannot have a result data type of both <type-1> and <type-2>.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified a CASE expression with a result data type of two
+data types. It must be one of data type.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4050">6.49. SQL 4050</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The operands of the <name> predicate must be comparable character
+data types (that is, of the same character set and collation).</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified predicate <name>, whose operands are required to
+be character, with invalid operands.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4051">6.50. SQL 4051</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The first operand of function <name> must be character.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified the first operand of function <name> with a type
+other than character, which is required.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4052">6.51. SQL 4052</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The second operand of function <name> must be numeric.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified the first operand of function <name> with a type
+other than numeric, which is required.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4053">6.52. SQL 4053</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The third operand of function <name> must be numeric.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified the third operand of a function <name> with a
+type other than numeric, which is required.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4055">6.53. SQL 4055</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The select lists or tuples must have comparable data types. <type-1> and <type-2> are not comparable.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified select lists or tuples with incompatible data
+types.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4056">6.54. SQL 4056</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Exposed name <name> appears more than once.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified a statement with an exposed table <name> that
+appears more than once. For example:</p>
+</div>
+<div class="paragraph">
+<p>SELECT * FROM tblx, tblx;</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4057">6.55. SQL 4057</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Correlation name <name-1> conflicts with qualified identifier of table <name-2>.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified correlation <name-1>, which conflicts with a
+qualified identifier of table <name-2>. For example:</p>
+</div>
+<div class="paragraph">
+<p>SELECT * FROM tblx, tblz, tblx;</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4059">6.56. SQL 4059</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The first operand of function <name> must be numeric.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified the first operand of function <name> with a type
+other than numeric, which is required.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4060">6.57. SQL 4060</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Reading from and inserting, or updating in, or deleting from the
+same table, <name-1>, is not currently supported. <name-1> is contained by
+view(s) <name-2>.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You attempted to read from and insert, update, or delete within
+the same table <name-1>, which is not supported.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4061">6.58. SQL 4061</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Rows cannot be inserted into, or updated in, an individual table partition.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You attempted to insert or update rows in an individual table
+partition, which is not supported.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4062">6.59. SQL 4062</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The preceding error actually occurred in function <name>.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> Trafodion detected an error in function
+<name>. Errors that appear before this one refer to the low level
+computations that this function uses.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the function and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4063">6.60. SQL 4063</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The operands of function <name> must be comparable character data types (that is, of the same character set and collation).</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified operands for function <name> with non-comparable
+character data types.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4064">6.61. SQL 4064</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The operands of function <name> must be compatible character data
+types (that is, of the same character set).</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified operands for function <name> with incompatible
+character data types.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4065">6.62. SQL 4065</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The format, <format-string>, specified in the <name> function is not supported.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified the given <format-string> as an argument to function <name>, but that function does not
+support that <format-string>.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4066">6.63. SQL 4066</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The operands of a UNION must be of equal degree.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified operands of a UNION statement that are not of
+equal degree, which is required.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4067">6.64. SQL 4067</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The operands of function <name> must be character data types.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified invalid operands for function <name>. They must
+be operands of type character.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4068">6.65. SQL 4068</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The operand of function <name> must contain an even number of characters.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified invalid operands for function <name>. They must
+contain an even number of characters.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4069">6.66. SQL 4069</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Column <name> uses an unsupported collation.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified a column <name> that uses an unsupported
+collation.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4070">6.67. SQL 4070</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The operand of function <name> must be exact numeric.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified an invalid operand for function <name>. It must
+be type exact numeric.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4071">6.68. SQL 4071</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The first operand of function <name> must be a datetime.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified an invalid operand for function <name>. It must
+be datetime.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4072">6.69. SQL 4072</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The operand of function <name> must be a datetime containing a <part>.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified an invalid operand for function <name>. It must
+be a datetime operand containing the part listed in the message (that is, a date
+or a time).</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4073">6.70. SQL 4073</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The COLLATE clause may appear only after an expression of character data type, not <data-type>.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified the COLLATE clause after an expression that is
+not a character data type.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4074">6.71. SQL 4074</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">CONTROL QUERY successful.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> The CONTROL QUERY statement completed successfully.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> None.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Informational message only; no corrective action is needed.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4075">6.72. SQL 4075</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Division by zero occurred in constant expression <name>.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You attempted to divide by zero in constant expression
+<name>.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4076">6.73. SQL 4076</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Overflow occurred in constant expression <name>.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> There is an overflow in constant expression <name>.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4077">6.74. SQL 4077</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Function <name> accepts only one or two operands.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified an invalid argument in function <name>. This
+function accepts only one or two arguments, both numeric.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4078">6.75. SQL 4078</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Function <name> does not accept a weight operand.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified an invalid argument in function <name>. The
+first argument must be numeric.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4079">6.76. SQL 4079</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The operands of function <name> must be numeric.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified an invalid operand in function <name>. The
+operands must be numeric.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4082">6.77. SQL 4082</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Table, view or stored procedure <name> does not exist or is inaccessible.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You referred to table <name>, which does not exist or is
+inaccessible (for example, on a downed disk volume).</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4085">6.78. SQL 4085</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">File organization <name-1> of object <name-2> is not supported.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified an invalid file organization <name-1> (for
+example, "R" for Relative) for table <name-2>.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4086">6.79. SQL 4086</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Environment variable or define <value> does not exist.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified an environment variable or define <value> that
+does not exist.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Define the environment variable and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4087">6.80. SQL 4087</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Prototype value '<value>' is not a valid qualified name.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified a prototype <value> that is not a valid qualified
+name.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4088">6.81. SQL 4088</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The number of values in each TRANSPOSE item of a TRANSPOSE set must be equal.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified a TRANSPOSE set with an unequal number of values
+in each TRANSPOSE item.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4089">6.82. SQL 4089</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Check constraint <name> contains a sub query. This is not yet supported.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified a constraint <name> that contains a sub query,
+which is not supported.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4093">6.83. SQL 4093</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The number of output dynamic parameters (<value-1>) must equal the number of selected values (<value-2>).</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> Trafodion requires that the number of
+output dynamic parameters, <value-1), match the number of selected
+values, <value-2>.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4094">6.84. SQL 4094</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The number of output host variables (<value-1>) must equal the
+number of selected values (<value-2>).</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> Trafodion requires that the number of
+output host variables, <value-1>, match the number of selected values,
+<value-2>.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4095">6.85. SQL 4095</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">A DEFAULT whose value is NULL is not allowed in <object-name>.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You included a NULL operand in <object-name>, which is not
+supported.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4096">6.86. SQL 4096</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">A DEFAULT specification is currently allowed only when simply
+contained in the VALUES list of an INSERT.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified a DEFAULT value that was not contained in the
+VALUES list of an INSERT.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4097">6.87. SQL 4097</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">A NULL operand is not allowed in function <name>.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You attempted to use a NULL operand in function <name>, which
+is not supported.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4098">6.88. SQL 4098</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">A NULL operand is not allowed in operation <name>.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You included a NULL operand in operation <name>, which is not
+supported.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4099">6.89. SQL 4099</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">A NULL operand is not allowed in predicate <name>.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You included a NULL operand in predicate <name>, which is not
+supported.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4100">6.90. SQL 4100</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">A NULL value is not allowed in a select list unless it is CAST to some data type.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You specified a NULL value in a select list that is not cast to
+a data type, which is required.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4101">6.91. SQL 4101</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">If <name> is intended to be a further table reference in the FROM
+clause, the preceding join search condition must be enclosed in
+parentheses.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> A syntax error has caused the Trafodion database software to
+treat object <name> as an ambiguous entity.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Check the syntax for a missing parenthesis and resubmit. If
+the object is not intended as a table reference in the FROM clause, use
+the error messages that accompany this one to diagnose the problem.
+Correct the syntax and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4102">6.92. SQL 4102</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The [FIRST/ANY n] syntax can be used only in an outermost SELECT
+statement that is not contained in a UNION or INSERT.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You attempted to use either a FIRST n or an ANY n clause in
+other than an outermost SELECT statement.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> The operation fails.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Remove the <code>FIRST n</code> or <code>ANY n</code> clause and resubmit.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4104">6.93. SQL 4104</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">If a character literal was intended, you must use the single quote
+delimiter: <literal>. The use of double quotes causes {project-name} to
+interpret <column-name> as a delimited identifier column name.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p>Where <column-name> is a delimited ANSI identifier, such as MYCOL.</p>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> You attempted to select from a table using a character literal,
+but you used double quotes as the delimiter instead of single quotes.</p>
+</div>
+<div class="paragraph">
+<p>For example, if you enter this statement, in which "Lower" is a
+character literal:</p>
+</div>
+<div class="paragraph">
+<p>>>select * from T050a where a="Lower"; you will receive this error:</p>
+</div>
+<div class="ulist">
+<ul>
+<li>
+<p>ERROR[4001] Column "Lower" is not found. Tables in scope:
+CAT.SCH.T050A. Default schema: CAT.SCH.</p>
+</li>
+<li>
+<p>ERROR[4104] If a character literal was intended, you must use the
+single quote delimiter instead of the double: 'Lower' instead of
+"Lower".</p>
+</li>
+</ul>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> Nothing is selected.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Replace the double quotes with single quotes.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4105">6.94. SQL 4105</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">Translation name is not recognized.</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p><strong>Cause:</strong> Trafodion does not recognize the
+translation name.</p>
+</div>
+<div class="paragraph">
+<p><strong>Effect:</strong> Trafodion is unable to compile the
+statement.</p>
+</div>
+<div class="paragraph">
+<p><strong>Recovery:</strong> Use one of the supported translation names.</p>
+</div>
+</div>
+<div class="sect2">
+<h3 id="SQL-4106">6.95. SQL 4106</h3>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">The character set for the operand of function <name-1> must be <name-2>.</code></pre>
<TRUNCATED>