JR33438: SQL BODY MIGHT BE MISSING UNDER OPEN DEFINITION PANEL FOR A STOR ED PROCEDURE WHEN USING VISUAL STUDIO .NET ADD-INS

DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error 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.
  

Local fix

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.
  

Problem conclusion

• First fixed in DB2 UDB Version 9.5, Fixpak 5
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  IC63128

Fix information

• Fixed component name

  DB2 CPE WINDOWS

• Fixed component ID

  5724B5601

Applicable component levels

• R950 PSN

     UP