本文介绍了DB2 SQL 错误:SQLCODE:-206，SQLSTATE:42703的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我收到了这个 JDBC 异常.我google了一下，但解释很抽象.
I am getting this JDBC exception. I googled it but the explanation was very abstract.
DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703
com.misys.liq.jsqlaccess.adapter.jdbcadapter.util.JDBCAdapterException: com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703,
推荐答案
这仅表示检测到未定义的列或参数名称.DB2 给出的错误应该指出可能是什么:
That only means that an undefined column or parameter name was detected. The errror that DB2 gives should point what that may be:
DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=[THE_UNDEFINED_COLUMN_OR_PARAMETER_NAME], DRIVER=4.8.87
仔细检查您的表定义.也许你只是错过了添加一些东西.
Double check your table definition. Maybe you just missed adding something.
我也试过用谷歌搜索这个问题并看到了这个:
I also tried google-ing this problem and saw this:
http://www.coderanch.com/t/515475/JDBC/databases/sql-insert-statement-giving-sqlcode
这篇关于DB2 SQL 错误:SQLCODE:-206，SQLSTATE:42703的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！