日期:2014-05-16  浏览次数:20668 次

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?