Db2 Sql Error: Sqlcode: -206, Sqlstate: 42703 [Closed]

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, 
4

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:

James H. Sterling

James H. Sterling

Environmental Science & Climate Journalist

James Sterling reports on renewable energy developments, climate policy, ecological conservation, and green tech innovations around the globe.

Share this article
Twitter Facebook Pinterest