DB2的常见SQLCODE所表示负数的含义

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 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. SQL0080 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 data 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. SQL0103 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 Explanation: 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 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. SQL0115 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 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 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 -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 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: 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 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/400 system. SQL0150 SQLCODE -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 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 FOREIGN 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 -161 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 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 timestamp 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 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 42837 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 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 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 &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 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 Explanation: 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 declared 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 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 relational 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 SQLCODE -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 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 SQLCODE -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 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: Character 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 expression 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 table 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 SQLSTATE 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 DataLink 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 &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, 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 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 Explanation: UNION operands not 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 22018 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. SQL0429 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 SQLSTATE 54023 Explanation: Maximum # of parameters on CALL exceeded. SQL0443 SQLCODE -443 SQLSTATE 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 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: Attributes of parameter &1 not valid for procedure. SQL0452 SQLCODE -452 SQLSTATE 428A1 Explanation: Unable to access a file that is referred to by a file reference variable. SQL0453 SQLCODE -453 SQLSTATE 42880 Explanation: Return type for function &1 in &2 not compatible with CAST TO type. SQL0454 SQLCODE -454 SQLSTATE 42723 Explanation: Function &1 in &2 with the same signature already exists. SQL0455 SQLCODE -455 SQLSTATE 42882 Explanation: Specific name not 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 signature. SQL0461 SQLCODE -461 SQLSTATE 42846 Explanation: Cast from &1 to &2 not supported. SQL0463 SQLCODE -463 SQLSTATE 39001 Explanation: SQLSTATE &4 returned from routine &1 in &2 not valid. 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 not allowed for parameter &4 in procedure. SQL0473 SQLCODE -473 SQLSTATE 42918 Explanation: User-defined type &1 cannot be created. 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 cannot 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. SQL0487 SQLCODE -487 SQLSTATE 38001 Explanation: SQL statements not allowed. SQL0490 SQLCODE -490 SQLSTATE 428B7 Explanation: Numeric value &1 not valid. SQL0491 SQLCODE -491 SQLSTATE 42601 Explanation: RETURNS clause required on CREATE FUNCTION statement. SQL0492 SQLCODE -492 SQLSTATE