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