|
Problem IC63128
|
Status: Closed |
SQL BODY MIGHT BE MISSING UNDER OPEN DEFINITION PANEL FOR A STOR ED PROCEDURE WHEN USING VISUAL STUDIO .NET ADD-INS |
| product: |
DB2 CONNECT / DB2CONNCT / 970 - DB2 |
| Problem description: |
When using the Visual Studio .NET add-ins (VSAI) with Microsoft
Visual Studio 2005 or 2008, you may receive a compile error
when trying to alter a stored procedure from within the "Open
Definition" panel in VSAI.
.
The "Open Definition" panel should display an SQL Body that
contains the stored procedure's SQL Body (everything from the
first 'BEGIN' to the last 'END'). The problem is that sometimes
the SQL Body might be missing. When you attempt to recreate the
stored procedure using VSAI, the new stored procedure will be
created without a body, and that could result in a compile time
error. |
| Problem Summary: |
Users Affected: Visual Studio .NET addin users
Problem Description:
When using the Visual Studio .NET add-ins (VSAI) with Microsoft
Visual Studio 2005 or 2008, you may receive a compile error
when trying to alter a stored procedure from within the "Open
Definition" panel in VSAI. |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 UDB Version 9.7, Fixpak 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.09.2009
22.12.2009
22.12.2009 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
