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

1、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

2、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 r

3、outine &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 Ex

4、planation: 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 wi

5、th &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

6、 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 const

7、ant 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 c

8、urrent 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 SQL

9、CODE -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 E

10、xplanation: 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. S

11、QL0130 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 SQLSTAT

12、E 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: Resul

13、t 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 s

14、ystem. 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. SQL0