ASP源码.NET源码PHP源码JSP源码JAVA源码DELPHI源码PB源码VC源码VB源码Android源码
当前位置:首页 >> 数据库 >> DB2 >> DB2-SQLCODE/DB2错误码大全

DB2-SQLCODE/DB2错误码大全

来源:网络整理     时间:2017-04-11     关键词:

本篇文章主要介绍了" DB2-SQLCODE/DB2错误码大全",主要涉及到方面的内容,对于DB2感兴趣的同学可以参考一下: SQL error codes###SQLCODEDescription###-007statement contains the illegal charac...



SQL error codes

<

以上就介绍了 DB2-SQLCODE/DB2错误码大全,包括了方面的内容,希望对DB2有兴趣的朋友有所帮助。

本文网址链接:http://www.codes51.com/article/detail_4265585.html

相关图片

相关文章

###SQLCODEDescription
###-007statement contains the illegal character invalid-character
###-010the string constant beginning string is not terminated
###-011comment not closed
###-029into clause required
###-051identifier-name (sql-type) was previously declared or referenced
###-056an sqlstate or sqlcode variable declaration is in a nested compound statement
###-057the return statement in an sql function must return a value.
###-058value specified on return statement must be an integer
###-060invalid specification-type specification : specification-value
###-078parameter names must be specified for routine routine-name
###-079qualifier for object name was specified as qualifier1 but qualifier2 is required
###-084unacceptable sql statement
###-087a null value was specified in a context where a null is not allowed
###-096variable variable-name does not exist or is not supported by the server and a default value was not provided
###-097the use of long varchar or long vargraphic is not allowed in this context
###-101the statement is too long or too complex
###-102string constant is too long. string begins string
###-103constant is an invalid numeric constant
###-104illegal symbol “token”. some symbols that might be legal are: token-list
###-105invalid string
###-107the name name-value is too long. maximum allowable size is maximum-size
###-108the name name is qualified incorrectly
###-109clause-type clause is not permitted
###-110invalid hexadecimal constant beginning constant
###-111an aggregate function does not include a column name
###-112the operand of an aggregate function includes an aggregate function, an olap specification, or a scalar fullselect
###-113invalid character found in: string, reason code nnn
###-114the location name location does not match the current server
###-115a predicate is invalid because the comparison operator operator is followed by a parenthesized list or by any or all without a subquery
###-117the number of values assigned is not the same as the number of specified or implied columns
###-118the object table or view of the delete or update statement is also identified in a from clause
###-119a column or expression in a having clause is not valid
###-120an aggregate function or olap specification is not valid in the context in which it was invoked
###-121the column name is identified more than once in the insert or update operation or set transition variable statement
###-122column or expression in the select list is not valid
###-123the parameter in position n in the function name must be a constant or keyword
###-125an integer in the order by clause does not identify a column of the result
###-126the select statement contains both an update clause and an order by clause
###-127distinct is specified more than once in a subselect
###-128invalid use of null in a predicate
###-129the statement contains too many table names
###-130the escape clause consists of more than one character, or the string pattern contains an invalid occurrence of the escape character
###-131statement with like predicate has incompatible data types
###-132an operand of value is not valid
###-133an aggregate function in a subquery of a having clause is invalid because all column references in its argument are not correlated to the group by result that the having clause is applied to
###-134improper use of a string, lob, or xml value
###-136sort cannot be executed because the sort key length too long
###-137the length resulting from operation is greater than maximum-length
###-138the second or third argument of the substr or substring function is out of range
###-142the sql statement is not supported
###-144invalid section number number
###-147alter function function-name failed because source functions or spatial functions cannot be altered
###-148the source table or tablespace source-name cannot be altered, reason reason-code
###-150the object of the insert, delete, update, merge, or truncate statement is a view, system-maintained materialized query table, or transition table for which the requested operation is not permitted
###-151the update operation is invalid because the catalog description of column column-name indicates that it cannot be updated
###-152the drop clause clause in the alter statement is invalid because constraint-name is a constraint-type
###-153the statement is invalid because the view or table definition does not include a unique name for each column
###-154the statement failed because view or table definition is not valid
###-156the statement does not identify a table
###-157only a table name can be specified in a foreign key clause. object-name is not the name of a table.
###-158the number of columns specified for name is not the same as the number of columns in the result table.
###-159the statement references object-name which identifies an actual-type rather than an expected-type
###-160the with check option clause is not valid for the specified view
###-161the insert or update is not allowed because a resulting row does not satisfy the view definition