Question

com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-420, SQLSTATE=22018, SQLERRMC=INTEGER,

严重: Servlet.service() for servlet action threw exception
com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-420, SQLSTATE=22018, SQLERRMC=INTEGER, DRIVER=3.61.75
at com.ibm.db2.jcc.am.ed.a(ed.java:668)
at com.ibm.db2.jcc.am.ed.a(ed.java:60)
at com.ibm.db2.jcc.am.ed.a(ed.java:127)
at com.ibm.db2.jcc.am.gn.b(gn.java:2239)
at com.ibm.db2.jcc.am.gn.c(gn.java:2222)
at com.ibm.db2.jcc.t4.cb.k(cb.java:369)
at com.ibm.db2.jcc.t4.cb.a(cb.java:61)
at com.ibm.db2.jcc.t4.q.a(q.java:50)
at com.ibm.db2.jcc.t4.sb.b(sb.java:228)
at com.ibm.db2.jcc.am.hn.mc(hn.java:2924)
at com.ibm.db2.jcc.am.hn.b(hn.java:3873)
at com.ibm.db2.jcc.am.hn.ec(hn.java:720)
at com.ibm.db2.jcc.am.hn.executeUpdate(hn.java:703)

Answer 1

调用INTEGER函数的时候存入了非法的字符串。这个字符串只能够包含数字。
有可能是传入了一个float数的字符串作为Integer的参数。

$ db2 ? sql420

SQL0420N Invalid character found in a character string argument of the
function "<function-name>".

Explanation:

The function "<function-name>" has a character string argument that
contains a character that is not valid in a numeric SQL constant. The
function may have been called as a result of using the CAST
specification with "<function-name>" as the target data type or when an
argument is implicitly cast to a numeric data type. The function or data
type used in the SQL statement may be a synonym for "<function-name>".

If a decimal character is specified in the DECIMAL function then that is
the character that must be used in place of the default decimal
character.

User response:

Ensure that the character strings that are being converted to numeric
types contain only characters that are valid in numeric SQL constants,
using the decimal character, if specified.

sqlcode: -420
sqlstate: 22018