db2 sql error sqlcode=-205 sqlstate=42703
action: The statement cannot be executed. Programmer db2 42703 response: Verify that the column and table names are specified correctly (including any required qualifiers) in the SQL statement. <- BACK TO INDEX This is a free Service. I assume no warranty for misprints, and for the correctness and completeness of information and entries.
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the sqlcode 203 workings and policies of this site About Us Learn more about
Sqlcode=-117Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions
Sqlcode=-612 Sqlstate=42711Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. http://www.sqlerror.de/db2_sql_error_-205_sqlstate_42703.html Join them; it only takes a minute: Sign up DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703 [closed] up vote 8 down vote favorite 1 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 share|improve this question http://stackoverflow.com/questions/24257615/db2-sql-error-sqlcode-206-sqlstate-42703 edited Aug 16 at 14:45 Jarrod Roberson 39.7k15109186 asked Jun 17 '14 at 7:05 praveen_mohan 132129 closed as unclear what you're asking by Clockwork-Muse, julienc, Soner Gönül, Ivan Ferić, Pinal Jul 23 '14 at 7:38 Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question. I'm sure the DB2 reference manual contains a less abstract explanation. –mustaccio Jun 17 '14 at 11:22 add a comment| 1 Answer 1 active oldest votes up vote 18 down vote 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.codera