Back

Explore Courses Blog Tutorials Interview Questions

DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703

0 votes
2 views
in SQL by (6.1k points)

I am getting this JDBC exception. I searched on the internet though couldn't find an answer.

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,

1 Answer

0 votes
by (12.7k points)

That simply means that an undefined column or parameter name was detected. The error 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 simply missed adding something.

Interested in SQL?  Register to this SQL Certification course and get certified.

Related questions

0 votes
1 answer
DB2 SQL error sqlcode=-104 sqlstate=42601
asked Dec 27, 2020 in SQL by Appu (6.1k points)
0 votes
1 answer
ERRORCODE=-4461, SQLSTATE=42815 in DB2
asked Dec 17, 2020 in SQL by Appu (6.1k points)
0 votes
1 answer
SQL Error: 17008, SQLState: null
asked Dec 2, 2020 in SQL by Appu (6.1k points)
0 votes
1 answer
How to update multiple columns in single update statement in DB2
asked Jan 3, 2021 in SQL by Appu (6.1k points)

Browse Categories

© COPYRIGHT 2011-2023 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...