《DB2的常见SQLCODE所表示负数的含义.docx》由会员分享，可在线阅读，更多相关《DB2的常见SQLCODE所表示负数的含义.docx（39页珍藏版）》请在三一文库上搜索。
1、DB2的常见SQLCODE所表示负数的含义SQL0007 SQLCODE -07? SQLSTATE 42601 ?Explanation: Character &1 (HEX &2) not valid in SQL statement.SQL0010 SQLCODE-10? SQLSTATE 42603?Explanation: String constant beginning &1 not delimited.SQL0029 SQLCODE -29? SQLSTATE 42601 ?Explanation: INTO clause missing from embedded SELEC
2、T statement.SQL0051 SQLCODE-51? SQLSTATE 3C000?Explanation: Cursor or procedure &1 previously declared.SQL0060 SQLCODE -60? SQLSTATE 42815?Explanation: Value &3 for argument &1 of &2 function not valid.SQL0078 SQLCODE -78? SQLSTATE 42629?Explanation: Parameter name required for routine &1 in &2.SQL0
3、080 SQLCODE -80? SQLSTATE 42978?Explanation: Indicator variable &1 not SMALLINT type.SQL0084 SQLCODE -84? SQLSTATE 42612?Explanation: Host variable not permitted here.SQL0097 SQLCODE -97? SQLSTATE 42601 ?Explanation: Use of data type not valid.SQL0099 SQLCODE -99? SQLSTATE 42992?Explanation: Operato
4、r in join condition not valid.SQL0101 SQLCODE-101? SQLSTATE 54001,54010, 54011?Explanation: SQL statement too long or complex.SQL0102 SQLCODE-102? SQLSTATE 54002?Explanation: String constant beginning with &1 too long.SQL0103 SQLCODE-103? SQLSTATE 42604?Explanation: Numeric constant &1 not valid.SQL
5、0104 SQLCODE-104? SQLSTATE 42601?Explanation: Token &1 was not valid. Valid tokens: &2.SQL0105 SQLCODE-105? SQLSTATE 42604?Explanation: Mixed or graphic string constant not valid.SQL0106 SQLCODE -106? SQLSTATE 42611?SQL0107 SQLCODE-107? SQLSTATE 42622?Explanation: &1 too long. Maximum &2 characters.
6、SQL0109 SQLCODE-109? SQLSTATE 42601?Explanation: &1 clause not allowed.SQL0110 SQLCODE-110? SQLSTATE 42606?Explanation: Hexadecimal constant beginning with &1 not valid.SQL0112 SQLCODE-112? SQLSTATE 42607?Explanation: Argument of function &1 is another function.SQL0113 SQLCODE-113? SQLSTATE 28000, 2
7、E000, 42602?Explanation: Name &1 not allowed.SQL0114 SQLCODE-114? SQLSTATE 42961 ?Explanation: Relational database &1 not the same as current server &2.SQL0115 SQLCODE-115? SQLSTATE 42601 ?Explanation: Comparison operator &1 not valid.SQL0117 SQLCODE-117? SQLSTATE 42802?Explanation: Statement insert
8、s wrong number of values.SQL0118 SQLCODE-118? SQLSTATE 42902?SQL0119 SQLCODE-119? SQLSTATE 42803?Explanation: Column &1 in HAVING clause not in GROUP BY.SQL0120 SQLCODE-120? SQLSTATE 42903?Explanation: Use of column function &2 not valid.SQL0121 SQLCODE -121 ? SQLSTATE 42701 ?Explanation: Duplicate
9、column name &1 in INSERT or UPDATE.SQL0122 SQLCODE-122? SQLSTATE 42803?Explanation: Column specified in SELECT list not valid.SQL0125 SQLCODE-125? SQLSTATE 42805?Explanation: ORDER BY column number &1 not valid.SQL0128 SQLCODE-128? SQLSTATE 42601?Explanation: Use of NULL is not valid.SQL0129 SQLCODE
10、-129? SQLSTATE 54004?Explanation: Too many tables in SQL statement.SQL0130 SQLCODE-130? SQLSTATE 22019, 22025?Explanation: Escape character &1 or LIKE pattern not valid.SQL0131 SQLCODE -131 ? SQLSTATE 42818?SQL0132 SQLCODE-132? SQLSTATE 42824?Explanation: LIKE predicate not valid.SQL0133 SQLCODE-133
11、? SQLSTATE 42906?Explanation: Operator on correlated column in SQL function not valid.SQL0134 SQLCODE-134? SQLSTATE 42907?Explanation: Argument of function too long.SQL0136 SQLCODE-136? SQLSTATE 54005?Explanation: ORDER BY or GROUP BY columns too long.SQL0137 SQLCODE-137? SQLSTATE 54006?Explanation:
12、 Result too long.SQL0138 SQLCODE -138? SQLSTATE 22011 ?Explanation: Argument &1 of SUBSTR function not valid.SQL0144 SQLCODE-144? SQLSTATE 58003?Explanation: Section number not valid.SQL0145 SQLCODE-145? SQLSTATE 55005?Explanation: Recursion not supported for an application server other than the AS/
13、400 system.Explanation: View or logical file &1 in &2 read-only.SQL0151 SQLCODE-151? SQLSTATE 42808?Explanation: Column &1 in table &2 in &3 read-only.SQL0152 SQLCODE-152? SQLSTATE 42809?Explanation: Constraint type not valid for constraint &1 in &2.SQL0153 SQLCODE-153? SQLSTATE 42908?Explanation: C
14、olumn list required for CREATE VIEW.SQL0154 SQLCODE-154? SQLSTATE 42909?Explanation: UNION and UNION ALL for CREATE VIEW not valid.SQL0156 SQLCODE-156? SQLSTATE 42809?Explanation: &1 in &2 not a table.SQL0157 SQLCODE-157? SQLSTATE 42810?Explanation: View &1 in &2 not valid in FOREIGN KEY clause.SQL0
15、158 SQLCODE -158? SQLSTATE 42811 ?Explanation: Number of columns specified not consistent.SQL0159 SQLCODE-159? SQLSTATE 42809?SQL0160 SQLCODE-160? SQLSTATE 42813?Explanation: WITH CHECK OPTION not allowed for view &1 in &2.SQL0161 SQLCODE-161? SQLSTATE 44000?Explanation: INSERT/UPDATE not allowed du
16、e to WITH CHECK OPTION.SQL0170 SQLCODE-170? SQLSTATE 42605?Explanation: Number of arguments for function &1 not valid.SQL0171 SQLCODE -171 ? SQLSTATE 42815?Explanation: Argument &1 of function &2 not valid.SQL0175 SQLCODE-175? SQLSTATE 58028?Explanation: COMMIT failed.SQL0180 SQLCODE-180? SQLSTATE 2
17、2007?Explanation: Syntax of date, time, or timestamp value not valid.SQL0181 SQLCODE-181? SQLSTATE 22007?Explanation: Value in date, time, or timestamp string not valid.SQL0182 SQLCODE-182? SQLSTATE 42816?Explanation: A date, time, or timestamp expression not valid.SQL0183 SQLCODE-183? SQLSTATE 2200
18、8?SQL0184 SQLCODE-184? SQLSTATE 42610?Explanation: Parameter marker not valid in expression.SQL0187 SQLCODE-187? SQLSTATE 42816?Explanation: Use of labeled duration is not valid.SQL0188 SQLCODE-188? SQLSTATE 22503, 28000, 2E000?Explanation: &1 is not a valid string representation of an authorization
19、 name or a relational database name.SQL0189 SQLCODE-189? SQLSTATE 22522?Explanation: Coded Character Set Identifier &1 is not valid.SQL0190 SQLCODE-190? SQLSTATE 42837?Explanation: Attributes of column &3 in &1 in &2 not compatible.SQL0191 SQLCODE-191? SQLSTATE 22504?Explanation: MIXED data not prop
20、erly formed.SQL0192 SQLCODE-192? SQLSTATE 42937?Explanation: Argument of TRANSLATE function not valid.SQL0194 SQLCODE-194? SQLSTATE 42848?Explanation: ORDER BY column &1 not in results table.SQL0196 SQLCODE-196? SQLSTATE 42817?Explanation: Column &3 in &1 in &2 cannot be dropped with RESTRICT.SQL019
21、7 SQLCODE-197? SQLSTATE 42877?Explanation: Column &1 cannot be qualified.SQL0198 SQLCODE-198? SQLSTATE 42617?Explanation: SQL statement empty or blank.SQL0199 SQLCODE-199? SQLSTATE 42601?Explanation: Keyword &1 not expected. Valid tokens: &2.SQL0203 SQLCODE -203? SQLSTATE 42702?Explanation: Column &
22、1 is ambiguous.SQL0204 SQLCODE -204? SQLSTATE 42704?Explanation: &1 in &2 type *&3 not found.SQL0205 SQLCODE -205? SQLSTATE 42703?Explanation: Column &1 not in table &2.SQL0206 SQLCODE -206? SQLSTATE 42703?SQL0212 SQLCODE-212? SQLSTATE 42712?Explanation: Duplicate table designator &1 not valid.SQL02
23、14 SQLCODE-214? SQLSTATE 42822?Explanation: ORDER BY expression is not valid.SQL0221 SQLCODE-221? SQLSTATE 42873?Explanation: Number of rows &2 not valid.SQL0225 SQLCODE -225? SQLSTATE 42872?Explanation: FETCH not valid; cursor &1 not declared with SCROLL.SQL0226 SQLCODE -226? SQLSTATE 24507?Explana
24、tion: Current row deleted or moved for cursor &1.SQL0227 SQLCODE -227? SQLSTATE 24513?Explanation: FETCH not valid, cursor &1 in unknown position.SQL0228 SQLCODE -228? SQLSTATE 42620?Explanation: FOR UPDATE OF clause not valid with SCROLL for cursor &1.SQL0231 SQLCODE-231? SQLSTATE 22006?SQL0250 SQL
25、CODE -250? SQLSTATE 42718?Explanation: Indicator variable required.SQL0251 SQLCODE-251? SQLSTATE 2E000, 42602?Explanation: Character in relational database name &1 is not valid.SQL0255 SQLCODE -255? SQLSTATE 42999?Explanation: DB2 Multisystem query error.SQL0256 SQLCODE -256? SQLSTATE 42998?Explanat
26、ion: Constraint &1 in &2 not allowed on distributed file.SQL0270 SQLCODE -270? SQLSTATE 42997?Explanation: Unique index not allowed.SQL0301 SQLCODE-301? SQLSTATE 07006,42895?Explanation: Input host variable &2 or argument &1 not valid.SQL0302 SQLCODE -302? SQLSTATE 22001,22003, 22023, 22024?Explanat
27、ion: Conversion error on input host variable &2.SQL0303 SQLCODE -303? SQLSTATE 22001,42806?Explanation: Host variable &1 not compatible with SELECT item.SQL0304 SQLCODE -304? SQLSTATE 22003, 22023, 22504?SQL0306 SQLCODE -306? SQLSTATE 42863?Explanation: Undefined host variable in REXX.SQL0311 SQLCOD
28、E-311 ? SQLSTATE 22501 ?Explanation: Length in a varying-length host variable not valid.SQL0312 SQLCODE-312? SQLSTATE 42618?Explanation: Host variable &1 not defined or not usable.SQL0313 SQLCODE-313? SQLSTATE 07001,07004?Explanation: Number of host variables not valid.SQL0328 SQLCODE -328? SQLSTATE
29、 42996?Explanation: Column &1 not allowed in partitioning key.SQL0329 SQLCODE -329? SQLSTATE 0E000?Explanation: The SET PATH name list is not valid.SQL0330 SQLCODE -330? SQLSTATE 22021 ?Explanation: Character conversion cannot be performed.SQL0332 SQLCODE -332? SQLSTATE 57017?Explanation: Character
30、conversion between CCSID &1 and CCSID &2 not valid.SQL0334 SQLCODE -334? SQLSTATE 22524?Explanation: Error &1 occurred using DataLink data type.SQL0338 SQLCODE -338? SQLSTATE 42972?Explanation: JOIN expression not valid.SQL0340 SQLCODE -340? SQLSTATE 42726?Explanation: Duplicate name &1 for common t
31、able expression.SQL0341 SQLCODE-341? SQLSTATE 42835?Explanation: Cyclic references between common table expressions.SQL0346 SQLCODE -346? SQLSTATE 42836?Explanation: Recursion not allowed for common table expressions.SQL0350 SQLCODE -350? SQLSTATE 42962?Explanation: Column &1 is not valid as key fie
32、ld for index or constraint.SQL0351 SQLCODE-351? SQLSTATE 56084?Explanation: The AR is not at the same level and DB2/400 cannot transform the data type to a compatible type.Explanation: The AS is not at the same level and DB2/400 cannot transform the data type to a compatible type.SQL0357 SQLCODE -35
33、7? SQLSTATE 57050?Explanation: File server &1 used in DataLink not currently available.SQL0392 SQLCODE -392? SQLSTATE 42855?Explanation: Assignment of LOB to specified host variable not allowed.SQL0398 SQLCODE -398? SQLSTATE 428D2?Explanation: AS LOCATOR cannot be specified for a non-LOB parameter.S
34、QL0401 SQLCODE-401? SQLSTATE 42818?Explanation: Comparison operator &1 operands not compatible.SQL0402 SQLCODE -402? SQLSTATE 42819?Explanation: &1 use not valid.SQL0404 SQLCODE -404? SQLSTATE 22001 ?Explanation: Value for column &1 too long.SQL0405 SQLCODE -405? SQLSTATE 42820?SQL0406 SQLCODE -406?
35、 SQLSTATE 22003, 22023, 22504?Explanation: Conversion error on assignment to column &2.SQL0407 SQLCODE -407? SQLSTATE 23502?Explanation: Null values are not allowed in column &1.SQL0408 SQLCODE -408? SQLSTATE 42821 ?Explanation: INSERT or UPDATE value for column &1 not compatible.SQL0410 SQLCODE-410
36、? SQLSTATE 42820?Explanation: Floating point literal &1 not valid.SQL0412 SQLCODE-412? SQLSTATE 42823?Explanation: Subquery with more than one result column not valid.SQL0414 SQLCODE-414? SQLSTATE 42824?Explanation: Column &1 not valid in LIKE predicate.SQL0415 SQLCODE -415? SQLSTATE 42825?Explanati
37、on: UNION operands not compatible.SQL0417 SQLCODE -417? SQLSTATE 42609?Explanation: Combination of parameter markers not valid.Explanation: Use of parameter marker is not valid.SQL0419 SQLCODE -419? SQLSTATE 42911 ?Explanation: Negative scale not valid.SQL0420 SQLCODE -420? SQLSTATE 22018?Explanatio
38、n: Character in CAST argument not valid.SQL0421 SQLCODE-421? SQLSTATE 42826?Explanation: Number of UNION operands not equal.SQL0423 SQLCODE -423? SQLSTATE 0F001?Explanation: LOB locator &1 not valid.SQL0428 SQLCODE -428? SQLSTATE 25501 ?Explanation: SQL statement cannot be run.SQL0429 SQLCODE -429?
39、SQLSTATE 54028?Explanation: The maximum number of concurrent LOB locators has been reached.SQL0432 SQLCODE -432? SQLSTATE 42841 ?Explanation: A parameter marker cannot have the user-defined type name &1.SQL0433 SQLCODE -433? SQLSTATE 22001 ?Explanation: Significant digits truncated during CAST from
40、numeric to character.Explanation: Number of arguments on CALL must match procedure.SQL0441 SQLCODE -441 ? SQLSTATE 42601 ?Explanation: Clause or keyword &1 not valid where specified.SQL0442 SQLCODE -442? SQLSTATE 54023?Explanation: Maximum # of parameters on CALL exceeded.SQL0443 SQLCODE -443? SQLST
41、ATE 2Fxxx, 38501 ?Explanation: Trigger program or external procedure detected on error.SQL0444 SQLCODE -444? SQLSTATE 42724?Explanation: External program &4 in &1 not found.SQL0446 SQLCODE -446? SQLSTATE 22003?Explanation: Conversion error in assignment of argument &2.SQL0448 SQLCODE -448? SQLSTATE
42、54023?Explanation: Maximum parameters on DECLARE PROCEDURE exceeded.SQL0449 SQLCODE -449? SQLSTATE 42878?Explanation: External program name for procedure &1 in &2 not valid.SQL0451 SQLCODE-451? SQLSTATE 42815?Explanation: Unable to access a file that is referred to by a file reference variable.SQL04
43、53 SQLCODE -453? SQLSTATE 42880?Explanation: Return type for function &1 in &2 not compatible with CAST TO type.Explanation: User-defined type &1 cannot be created.Explanation: Function &1 in &2 with the same signature already exists.SQL0455 SQLCODE -455? SQLSTATE 42882?Explanation: Specific name no
44、t same as procedure name.SQL0456 SQLCODE -456? SQLSTATE 42710?Explanation: Specific name &3 in &2 already exists.SQL0457 SQLCODE -457? SQLSTATE 42939?Explanation: Name &1 in &2 not allowed for function.SQL0458 SQLCODE -458? SQLSTATE 42883?Explanation: Function &1 in &2 not found with matching signat
45、ure.SQL0461 SQLCODE-461? SQLSTATE 42846?Explanation: Cast from &1 to &2 not supported.SQL0463 SQLCODE -463? SQLSTATE 39001 ?SQL0469 SQLCODE -469? SQLSTATE 42886?Explanation: IN, OUT, INOUT not valid for parameter &4 in procedure &1 in &2.SQL0470 SQLCODE -470? SQLSTATE 39002?Explanation: NULL values
46、not allowed for parameter &4 in procedure.SQL0475 SQLCODE -475? SQLSTATE 42866?Explanation: RETURNS data type for function &3 in &4 not valid.SQL0476 SQLCODE -476? SQLSTATE 42725?Explanation: Function &1 in &2 not unique.SQL0478 SQLCODE -478? SQLSTATE 42893?Explanation: Object &1 in &2 of type &3 ca
47、nnot be dropped.SQL0483 SQLCODE -483? SQLSTATE 42885?Explanation: Parameters for function &1 in &2 not same as sourced function.SQL0484 SQLCODE -484? SQLSTATE 42733?Explanation: Routine &1 in &2 already exists.SQL0490 SQLCODE -490? SQLSTATE 428B7?Explanation: Numeric value &1 not valid.SQL0491 SQLCODE -491 ? SQLSTATE 42601 ?Explanation: RETURNS clause required on CREATE FUNCTION statem