---
title: "How to Resolve -206 SQL Error Object-Not-Valid in DB2"
description: "Here is a resolution for SQL error -206. You will get an error of object is not valid. Here are possible reasons for this error. Also given solution for how to fix it."
url: https://srinimf.com/2021/10/16/how-to-resolve-206-sql-error-object-not-valid-in-db2/
date: 2021-10-16
modified: 2026-10-10
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2021/10/pexels-photo-6238078.jpeg?fit=1880%2C1253&ssl=1
categories: ["DB2"]
tags: ["SQL Error Codes"]
type: post
lang: en
---

# How to Resolve -206 SQL Error Object-Not-Valid in DB2

In DB2, you will receive an error –[206](https://srinimf.com/2015/08/28/db2-error-codes-204-205-206/) during SELECT, INSERT, DELETE, UPDATE and MERGE SQL queries. The reason is the column name specified in the query not belongs to any Table. The SQLSTAE would be 42703.

This error you will also get during CREATE FUNCTION, ALTER FUNCTION, CREATE PROCEDURE or ALTER PROCEDURE.

Advertisements

## Possible Reasons

- The specified name is not a column of any of the source or target tables or views of the statement.
- In a SELECT or DELETE statement, the specified name is not a column of any of the tables or views that are identified in a FROM clause in the statement.
- In an INSERT, UPDATE, or MERGE statement, the specified name is not a column of the table, or view that was specified as the target of the data change statement.
- A column list of an SQL data change statement specified a name that is not a column of the target table or view of the statement.

### Resolution

- Ensure that the Columns/Tables that mentioned the SQL query are available.
- For a SELECT INTO statement, make sure that the index of an array element is not specified as a column in the INTO clause.

Related Posts

- [DB2 SQL Error Codes You Always Need](https://srinimf.com/2010/10/23/sql_error_codes/)DateOctober 23, 2010
- [SQL DB2: Error codes -204, -205, -206 Resolution](https://srinimf.com/2015/08/28/db2-error-codes-204-205-206/)DateAugust 28, 2015
- [How to Tune SQL Query 5 Ideas](https://srinimf.com/2015/02/14/5-more-db2-sql-performance-tips/)DateFebruary 14, 2015

### Share this:

-
- [Tweet](https://twitter.com/share)
- [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2021%2F10%2F16%2Fhow-to-resolve-206-sql-error-object-not-valid-in-db2%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2021%2F10%2Fpexels-photo-6238078.jpeg%3Ffit%3D1200%252C800%26ssl%3D1&description=How%20to%20Resolve%20-206%20SQL%20Error%20Object-Not-Valid%20%20in%20DB2)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2021/10/16/how-to-resolve-206-sql-error-object-not-valid-in-db2/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2021/10/16/how-to-resolve-206-sql-error-object-not-valid-in-db2/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2021/10/16/how-to-resolve-206-sql-error-object-not-valid-in-db2/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2021/10/16/how-to-resolve-206-sql-error-object-not-valid-in-db2/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20How%20to%20Resolve%20-206%20SQL%20Error%20Object-Not-Valid%20%20in%20DB2&body=https%3A%2F%2Fsrinimf.com%2F2021%2F10%2F16%2Fhow-to-resolve-206-sql-error-object-not-valid-in-db2%2F&share=email)
-

### Like this:

Like Loading…