Progress Worldwide Sites

Unable to delete column from Visual Studio 2010 Server Explorer

Printable View

« 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 Message

SQL0952N: 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