DB2 SQL错误：SQLCODE：-206，SQLSTATE：42703 [英] DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703

问题描述

我得到这个JDBC异常。我已经google了，但解释很抽象。

  DB2 SQL错误：SQLCODE：-206，SQLSTATE：42703 
 
 com.misys.liq.jsqlaccess.adapter.jdbcadapter.util.JDBCAdapterException：com.ibm.db2.jcc.a.SqlException：DB2 SQL错误：SQLCODE：-206，SQLSTATE：42703，
  

解决方案

这只意味着检测到未定义的列或参数名称。 DB2给出的错误应该指出可能是什么：

  DB2 SQL错误：SQLCODE = -206，SQLSTATE = 42703，SQLERRMC = [THE_UNDEFINED_COLUMN_OR_PARAMETER_NAME]，DRIVER = 4.8.87 
  

双重检查表格定义。也许你刚刚错过了添加的东西。

我也尝试google这个问题，看到这样：

http://www.coderanch.com/t/515475/JDBC/databases/sql -insert-statement-give-sqlcode

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, 

解决方案

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的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！