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 SELECT
2、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: SQL statement not allowed. SQL0090 SQLCODE -90 SQLSTATE 42618 Explanation: Host variable not permitted here. SQL0097 SQLCODE -97 SQLSTATE 42601 Explanation: Use of dat
4、a type not valid. SQL0099 SQLCODE -99 SQLSTATE 42992 Explanation: Operator 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. SQL01
5、03 SQLCODE -103 SQLSTATE 42604 Explanation: Numeric constant &1 not valid. SQL0104 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 Expla
6、nation: Precision specified for FLOAT column not valid. SQL0107 SQLCODE -107 SQLSTATE 42622 Explanation: &1 too long. Maximum &2 characters. SQL0109 SQLCODE -109 SQLSTATE 42601 Explanation: &1 clause not allowed. SQL0110 SQLCODE -110 SQLSTATE 42606 Explanation: Hexadecimal constant beginning with &1
7、 not valid. SQL0112 SQLCODE -112 SQLSTATE 42607 Explanation: Argument of function &1 is another function. SQL0113 SQLCODE -113 SQLSTATE 28000, 2E000, 42602 Explanation: Name &1 not allowed. SQL0114 SQLCODE -114 SQLSTATE 42961 Explanation: Relational database &1 not the same as current server &2. SQL
8、0115 SQLCODE -115 SQLSTATE 42601 Explanation: Comparison operator &1 not valid. SQL0117 SQLCODE -117 SQLSTATE 42802 Explanation: Statement inserts wrong number of values. SQL0118 SQLCODE -118 SQLSTATE 42902 Explanation: Table &1 in &2 also specified in a FROM clause. SQL0119 SQLCODE -119 SQLSTATE 42
9、803 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 column name &1 in INSERT or UPDATE. SQL0122 SQLCODE -122 SQLSTATE 42803 Explanation: Column sp
10、ecified 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 -129 SQLSTATE 54004 Explanation: Too many tables in SQL statement. SQL0130 SQLCODE -130 S
11、QLSTATE 22019, 22025 Explanation: Escape character &1 or LIKE pattern not valid. SQL0131 SQLCODE -131 SQLSTATE 42818 Explanation: Operands of LIKE not compatible or not valid. SQL0132 SQLCODE -132 SQLSTATE 42824 Explanation: LIKE predicate not valid. SQL0133 SQLCODE -133 SQLSTATE 42906 Explanation:
12、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: Result too long. SQL0138 S
13、QLCODE -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/400 system. SQL0150 SQLCOD
14、E -150 SQLSTATE 42807 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
15、Explanation: Column 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 FOREIG
16、N KEY clause. SQL0158 SQLCODE -158 SQLSTATE 42811 Explanation: Number of columns specified not consistent. SQL0159 SQLCODE -159 SQLSTATE 42809 Explanation: &1 in &2 not correct type. SQL0160 SQLCODE -160 SQLSTATE 42813 Explanation: WITH CHECK OPTION not allowed for view &1 in &2. SQL0161 SQLCODE -16
17、1 SQLSTATE 44000 Explanation: INSERT/UPDATE not allowed due 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
18、 Explanation: COMMIT failed. SQL0180 SQLCODE -180 SQLSTATE 22007 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 tim
19、estamp expression not valid. SQL0183 SQLCODE -183 SQLSTATE 22008 Explanation: The result of a date or timestamp expression not valid. SQL0184 SQLCODE -184 SQLSTATE 42610 Explanation: Parameter marker not valid in expression. SQL0187 SQLCODE -187 SQLSTATE 42816 Explanation: Use of labeled duration is
20、 not valid. SQL0188 SQLCODE -188 SQLSTATE 22503, 28000, 2E000 Explanation: &1 is not a valid string representation of an authorization name or a relational database name. SQL0189 SQLCODE -189 SQLSTATE 22522 Explanation: Coded Character Set Identifier &1 is not valid. SQL0190 SQLCODE -190 SQLSTATE 42
21、837 Explanation: Attributes of column &3 in &1 in &2 not compatible. SQL0191 SQLCODE -191 SQLSTATE 22504 Explanation: MIXED data not properly formed. SQL0192 SQLCODE -192 SQLSTATE 42937 Explanation: Argument of TRANSLATE function not valid. SQL0194 SQLCODE -194 SQLSTATE 42848 Explanation: KEEP LOCKS
22、 not allowed. SQL0195 SQLCODE -195 SQLSTATE 42814 Explanation: Last column of &1 in &2 cannot be dropped. SQL0196 SQLCODE -196 SQLSTATE 42817 Explanation: Column &3 in &1 in &2 cannot be dropped with RESTRICT. SQL0197 SQLCODE -197 SQLSTATE 42877 Explanation: Column &1 cannot be qualified. SQL0198 SQ
23、LCODE -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 &1 is ambiguous. SQL0204 SQLCODE -204 SQLSTATE 42704 Explanation: &1 in &2 type *&3
24、 not found. SQL0205 SQLCODE -205 SQLSTATE 42703 Explanation: Column &1 not in table &2. SQL0206 SQLCODE -206 SQLSTATE 42703 Explanation: Column &1 not in specified tables. SQL0208 SQLCODE -208 SQLSTATE 42707 Explanation: ORDER BY column &1 not in results table. SQL0212 SQLCODE -212 SQLSTATE 42712 Ex
25、planation: Duplicate table designator &1 not valid. SQL0214 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 declare
26、d with SCROLL. SQL0226 SQLCODE -226 SQLSTATE 24507 Explanation: 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
27、 cursor &1. SQL0231 SQLCODE -231 SQLSTATE 22006 Explanation: Position of cursor &1 not valid for FETCH of current row. SQL0250 SQLCODE -250 SQLSTATE 42718 Explanation: Local relational database not defined in the directory. SQL0251 SQLCODE -251 SQLSTATE 2E000, 42602 Explanation: Character in relatio
28、nal database name &1 is not valid. SQL0255 SQLCODE -255 SQLSTATE 42999 Explanation: DB2 Multisystem query error. SQL0256 SQLCODE -256 SQLSTATE 42998 Explanation: Constraint &1 in &2 not allowed on distributed file. SQL0270 SQLCODE -270 SQLSTATE 42997 Explanation: Unique index not allowed. SQL0301 SQ
29、LCODE -301 SQLSTATE 07006,42895 Explanation: Input host variable &2 or argument &1 not valid. SQL0302 SQLCODE -302 SQLSTATE 22001, 22003, 22023, 22024 Explanation: Conversion error on input host variable &2. SQL0303 SQLCODE -303 SQLSTATE 22001, 42806 Explanation: Host variable &1 not compatible with
30、 SELECT item. SQL0304 SQLCODE -304 SQLSTATE 22003, 22023, 22504 Explanation: Conversion error in assignment to host variable &2. SQL0305 SQLCODE -305 SQLSTATE 22002 Explanation: Indicator variable required. SQL0306 SQLCODE -306 SQLSTATE 42863 Explanation: Undefined host variable in REXX. SQL0311 SQL
31、CODE -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 SQLS
32、TATE 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. SQL0331 SQLCODE -331 SQLSTATE 22021 Explanation: Charact
33、er conversion cannot be performed. SQL0332 SQLCODE -332 SQLSTATE 57017 Explanation: Character conversion between CCSID &1 and CCSID &2 not valid. SQL0334 SQLCODE -334 SQLSTATE 22524 Explanation: Character conversion has resulted in truncation. SQL0338 SQLCODE -338 SQLSTATE 42972 Explanation: JOIN ex
34、pression not valid. SQL0340 SQLCODE -340 SQLSTATE 42726 Explanation: Duplicate name &1 for common table expression. SQL0341 SQLCODE -341 SQLSTATE 42835 Explanation: Cyclic references between common table expressions. SQL0346 SQLCODE -346 SQLSTATE 42836 Explanation: Recursion not allowed for common t
35、able expressions. SQL0350 SQLCODE -350 SQLSTATE 42962 Explanation: Column &1 is not valid as key field 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. SQL0352 SQLCODE -352 SQLST
36、ATE 56084 Explanation: The AS is not at the same level and DB2/400 cannot transform the data type to a compatible type. SQL0357 SQLCODE -357 SQLSTATE 57050 Explanation: File server &1 used in DataLink not currently available. SQL0358 SQLCODE -358 SQLSTATE 428D1 Explanation: Error &1 occurred using D
37、ataLink data type. 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. SQL0401 SQLCODE -401 SQLSTATE 42818 Explanation: Comparison operator
38、&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 Explanation: Numeric constant &1 out of range. SQL0406 SQLCODE -406 SQLSTATE 22003, 22023,
39、 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 SQLSTATE 42820 Explan
40、ation: 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 Explanation: UNION operands no
41、t compatible. SQL0417 SQLCODE -417 SQLSTATE 42609 Explanation: Combination of parameter markers not valid. SQL0418 SQLCODE -418 SQLSTATE 42610 Explanation: Use of parameter marker is not valid. SQL0419 SQLCODE -419 SQLSTATE 42911 Explanation: Negative scale not valid. SQL0420 SQLCODE -420 SQLSTATE 2
42、2018 Explanation: 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. SQL042
43、9 SQLCODE -429 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 numeric to character. SQL0440 SQLCODE -440 SQLSTATE 42884 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 SQLSTAT
