DB2 SQL error SQLCODE -206 SQLSTATE 42703

0 votes

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,

Can someone please help me with this?

Sep 5, 2022 in Database by Kithuzzz
 • 38,000 points • 1,617 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

That merely indicates that the name of an undef column or parameter was found. The error message that DB2 displays should indicate what it might be:

DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=[THE_UNDEFINED_COLUMN_OR_PARAMETER_NAME], DRIVER=4.8.87

Verify your table definition once again. Perhaps you simply forgot to add something. 

I hope this helps you.

answered Sep 6, 2022 by narikkadan
 • 63,600 points
edited 5 days ago

Related Questions In Database

0 votes
1 answer

Error: Cannot connect to the SQL Server on Ubuntu from SSMS - installing mssql on linux

Hey @Rajni, Verify if the server is running ...READ MORE

answered Mar 17, 2019 in Database by Anvit
 • 2,782 views
0 votes
1 answer

Error:Import SQL dump into PostgreSQL database

Hello, Here is the command you are looking ...READ MORE

answered May 4, 2020 in Database by Niroj
 • 82,840 points • 5,493 views
0 votes
1 answer

SQL error "ORA-01722: invalid number"

When an effort is made to convert ...READ MORE

answered Feb 15, 2022 in Database by Neha
 • 9,020 points • 3,333 views
0 votes
0 answers

MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

This is my Stored procedure : CREATE PROCEDURE ...READ MORE

Aug 14, 2022 in Database by Kithuzzz
 • 38,000 points • 7,560 views
0 votes
0 answers

Login to Microsoft SQL Server Error: 18456

When I try to connect to the SQL ...READ MORE

Aug 14, 2022 in Database by Kithuzzz
 • 38,000 points • 714 views
0 votes
0 answers

Error converting data type nvarchar to datetime SQL Server

I encountered this error: Error converting data type ...READ MORE

Aug 15, 2022 in Database by Kithuzzz
 • 38,000 points • 3,675 views
0 votes
1 answer

Restrictions while installing DB2 Server on Linux using DB2 Setup Wizard

Hey it would be helpful if you ...READ MORE

answered Mar 20, 2019 in Database by Yesha
 • 816 views
0 votes
1 answer

How to connect to IBM DB2 database from power Bi?

Hi, Follow these steps, to connect to IBM ...READ MORE

answered Mar 22, 2019 in Power BI by Cherukuri
 • 33,030 points • 12,282 views
0 votes
1 answer

How to connect to IBM DB2 database from Tableau?

Hi, Follow these steps, to connect to IBM ...READ MORE

answered Mar 22, 2019 in Tableau by Cherukuri
 • 33,030 points • 2,018 views
0 votes
1 answer

DB2 SQL error sqlcode=-104 sqlstate=42601

You missed the from clause: SELECT * from TCCAWZTXD.TCC_COIL_DEMODATA WHERE ...READ MORE

answered Sep 12, 2022 in Database by narikkadan
 • 63,600 points • 4,239 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.