VisualAge(R) for Java(TM)
Version 3.5

DB2(R) Stored Procedure Builder

RELEASE NOTES




Table of contents

1.0 Introduction
2.0 Prerequisites
3.0 Installing DB2 Stored Procedure Builder
4.0 Limitations and known problems
5.0 Hints and Tips
      5.1 Exporting a Stored Procedure Builder project file

1.0 Introduction 

IBM(R) DB2 Stored Procedure Builder enables you to create, install and test stored procedures. 

2.0 Prerequisites

The following must be installed prior to running Stored Procedure Builder:

1. IBM DB2 Version 6 or later
2. IBM DB2 Software Developer's Kit (SDK), including the IBM DB2 
Stored Procedure Builder component

Refer to the DB2 release notes for more information about configuring DB2 Universal Database for Stored Procedure Builder. 

If you need to create or use static stored procedures in Stored Procedure Builder, you must add the SQLJ Runtime Library project to your workspace.

To add the SQLJ Runtime Library to your workspace:

1. From the Workbench, select Window > Repository Explorer.
2. Select SQLJ Runtime Library from the Project Names pane.
3. Select an edition of the SQLJ Runtime Library from the Edition pane.
4. Select Editions > Add to Workspace. 

If you are using Stored Procedure Builder with DB2 databases Version 6 or later, you must have Fixpack 2 or higher installed on your machine.

3.0 Installing Stored Procedure Builder

To install Stored Procedure Builder, run the VisualAge for Java 3.5 installation program and select the Enhanced Database Support component. Installing this component will also install Stored Procedure Builder.

4.0 Limitations and known problems

Pop-up information and constraint checking windows might appear beneath the associated Stored Procedure Builder interface windows. This is a known problem that does not the affect the behavior of Stored Procedure Builder. 

To turn off pop-up information and constraint checking:

  1. In the Stored Procedure Builder project window, select File > Environment Properties.
  2. Click the Assistance tab.
  3. Deselect the Show pop-up information for interface controls check box and the Diagnose constraint violations check box.
  4. Click OK. 

When opening the Stored Procedure Builder online help in Netscape Navigator on Microsoft(R) Windows(R) 2000, you might receive the following error message:

Problem with shortcut. Unable to open [helpfile].htm.

Reinstall Netscape Navigator on Windows 2000 to correct this problem.

The online help for Stored Procedure Builder does not work in Netscape 4.7. Help will show up in the browser but will be accompanied by an error message stating that "Cannot open" the filename. This problem will not occur with Netscape Browsers earlier or later than Netscape 4.7. This problem may occur in some versions of Internet Explorer also. 

5.0 Hints and Tips

5.1 Exporting a Stored Procedure Builder project file

Stored Procedure Builder saves connection information and unbuilt stored procedure objects in a Stored Procedure Builder (*.SPP) project file. This project file is stored in the VisualAge for Java project that you used to launch Stored Procedure Builder. 

Because VisualAge for Java treats Stored Procedure Builder project files as resources, you must ensure that resource files are copied during a VisualAge for Java project export. If you export a  VisualAge for Java project to a JAR file or repository without  copying the resource files, the Stored Procedure Builder project  file is not automatically included in the export.

To export a VisualAge for Java project into a JAR file (including the Stored Procedure Builder project file):

  1. In the Workbench, select the Projects tab.
  2. In the tree view, select the project containing the Stored Procedure Builder project file that you want to export.
  3. Select File > Export. The Export SmartGuide opens.
  4. Select the Jar file radio button. Click Next.
  5. Make sure the Resource checkbox is selected. 
  6. Click the Details button next to the resources checkbox. 
  7. Select the Stored Procedure Builder (*.SPP) project file from the list of resource files. Click OK.
  8. Click Finish.

To export a VisualAge for Java project into a repository (including the Stored Procedure Builder project file):

  1. In the Workbench, select the Projects tab.
  2. In the tree view, select the VisualAge for Java project containing the Stored Procedure Builder project file that you want to export.
  3. Select File > Export. The Export SmartGuide opens.
  4. Select the Repository radio button. Click Next.
  5. Select a local or shared repository and enter the necessary repository information.
  6. Click Finish. 
  7. Import the repository you specified in step 5 into the targeted VisualAge for Java instance.
  8. In your file system, copy the Stored Procedure Builder project file from the source project subdirectory:
    x:\ibmvjava\ide\project_resources\your_project
    to the target project subdirectory. This ensures that the Stored Procedure Builder project file is restored in the target project.
    Note: In the example above, x:\ibmvjava is the drive and directory where VisualAge for Java 3.5 is installed and your_project is the name of the project subdirectory