Db2 Sql Error 42703
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About sqlcode=-727, sqlstate=56098, sqlerrmc=2;-206;42703 Us Learn more about Stack Overflow the company Business Learn more about hiring db2 sqlcode=-204 developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join
Sqlcode '-206', Sqlstate '42703'
the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up DB2 SQL error: SQLCODE: -206, http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n206.html 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 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 http://stackoverflow.com/questions/24257615/db2-sql-error-sqlcode-206-sqlstate-42703 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.coderanch.com/t/515475/JDBC/databases/sql-insert-statement-giving-sqlcode share|improve this answer answered Jul 23 '14 at 1:18 Fritz 629617 add a comment| Not the answer you're looking for? Browse other questions tagged db2 or ask your own question. asked 2 years ago viewed 88337 times active 1 month ago Lin
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn http://stackoverflow.com/questions/11104267/existing-db2-column-reported-as-not-being-a-column-of-the-table more about hiring developers or posting ads with us Stack Overflow Questions Jobs 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. Join them; it only takes a minute: Sign up Existing DB2 column reported as not being a column of the table up vote 2 down vote favorite In a Moodle 2 install running on DB2, db2 sql deleting a user is unsuccessful, returning an error reading from database: Debug info: [IBM][CLI Driver][DB2/LINUXX8664] SQL0206N "USERIDFROM" is not valid in the context where it is used. SQLSTATE=42703 SQLCODE=-206 SELECT * FROM mdl_message WHERE useridfrom = ? ORDER BY timecreated [array ( 0 => '28521', )] The error description for SQL0206N is clear, but useridfrom is a column of mdl_message: $ db2 describe table mdl_message Data type Column Column name schema Data type name Length Scale db2 sql error Nulls ------------------------- --------- ------------------- ---------- ----- ------ ID SYSIBM BIGINT 8 0 No USERIDFROM SYSIBM BIGINT 8 0 No USERIDTO SYSIBM BIGINT 8 0 No SUBJECT SYSIBM VARCHAR 200 0 Yes FULLMESSAGE SYSIBM VARCHAR 200 0 Yes FULLMESSAGEFORMAT SYSIBM SMALLINT 2 0 Yes FULLMESSAGEHTML SYSIBM VARCHAR 100 0 Yes SMALLMESSAGE SYSIBM VARCHAR 200 0 Yes NOTIFICATION SYSIBM SMALLINT 2 0 Yes CONTEXTURL SYSIBM VARCHAR 200 0 Yes CONTEXTURLNAME SYSIBM VARCHAR 200 0 Yes TIMECREATED SYSIBM BIGINT 8 0 No 12 record(s) selected. What else could cause this error? sql db2 moodle db2-luw share|improve this question asked Jun 19 '12 at 15:26 Marius Butuc 6,706145799 1 From the error message you're getting, it is unclear what the WHERE clause you're using is. Did you forget to put one in? –Kreg Jun 19 '12 at 15:30 That is a weird error, is there trigger on the table or something? Or is there some way to turn case-sensitivity on? And not accidently a 1 (one) or l (ell) or similar? Beyond that, I'm assuming TIMECREATED is a count of milli(or nano) seconds since the epoch, in UTC - to get around the fact that DB2 doesn't store the timezone information in timestamps? –Clockwork-Muse Jun 19 '12 at 15:35 Based on the error message, it looks like you passed a question mark to DB2 for