2024年3月29日发(作者：)

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.