Article

Unable to delete column from Visual Studio 2010 Server Explorer

« Go Back

Information

 
Environment
Question/Problem Description

Unable to delete column from Visual Studio 2010 Server Explorer using the Connect for ADO.NET DB2 provider, version 3.5.  The database version is DB2 on iSeries V6R1.

Clarifying Information
Steps to Reproduce:
  • Create new connection to DB2 iSeries in Visual Studio 2010 Server Explorer.
  • Drop Down connection name
  • Drop Down "Tables"
  • Right click table name for which to drop column and click "Update Definition"
  • This will launch "Progress DataDirect Connect for ADO.NET Edit Table Definition Wizard"
  • Click Next twice
  • Click on Column name and select "Remove"
  • Continue clicking Next until finished.
Error MessageSQL0952N: Processing of the SQL statement ended. Reason code 10.
Defect/Enhancement Number
Cause
The DB2 on iSeries server is returning a warning (inquiry message) because of possible data loss, requesting the client to Cancel or Ignore the requested operation. The ADO.NET client is unable to respond to the interactive request to type 'I' to ignore.  Therefore, the server throws an ErrorCode: -952 with SQLState: 57014 and Reason code 10.
Resolution
On DB2 for iSeries, change the message description default value to 'I'
CHGMSGD MSGID(CPA32B2) MSGF(QSYS/QCPFMSG) DFT('I')
Workaround
Notes
Attachment 
Feedback
 
Was this article helpful?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful.



Characters Remaining: 255

 



Copyright © 1993-2014. Progress Software Corporation. All Rights Reserved. See the next generation of application development and data connectivity software, try now!