IBM Support

Error -206 / SQL0206 using Data Edit functionality with DB2 z/OS in Compatibility Mode (CM)

Troubleshooting


Problem

You attempt to edit table data using the Data Edit functionality in Data Studio and you receive error -206 or SQL0206 similar to this: com.ibm.db2.jcc.am.SqlSyntaxErrorException: IS NOT VALID IN THE CONTEXT WHERE IT IS USED. SQLCODE=-206, SQLSTATE=42703, DRIVER=3.62.80

Symptom

com.ibm.db2.jcc.am.SqlSyntaxErrorExceptio exception reporting error -206.

[{"Product":{"code":"SS62YD","label":"IBM Data Studio"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"3.1.1;3.1;2.2.1.1;2.2.1;2.2.0.2;2.2.0.1;2.2;2.1.1;2.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

To view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

link to actual document

Document Information

More support for:
IBM Data Studio

Software version:
3.1.1, 3.1, 2.2.1.1, 2.2.1, 2.2.0.2, 2.2.0.1, 2.2, 2.1.1, 2.1

Operating system(s):
Linux, Windows

Document number:
477919

Modified date:
16 June 2018

UID

swg21610998

Manage My Notification Subscriptions

Page Feedback

Overview Annual report Corporate social responsibility Financing Investor Newsroom Security, privacy & trust Senior leadership Careers with IBM Website Blog Publications Automotive Banking Consumer Goods Energy Government Healthcare Insurance Life Sciences Manufacturing Retail Telecommunications Travel Our strategic partners Find a partner Become a partner - Partner Plus Partner Plus log in IBM TechXChange Community LinkedIn X Instagram YouTube Subscription Center Participate in user experience research Podcasts Contact IBM Privacy Terms of use Accessibility United States — English