Services Partners Company
Knowledge Base


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.

Steps to Reproduce
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 
Disclaimer

The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.



Feedback
 
Was this article helpful?

   

Your feedback is appreciated.

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



Characters Remaining: 255