Stored Procedure Builder

The SPB (Figure 8-2) is a graphical Windows-based application that supports the rapid development of DB2 stored procedures written in either Java or SQL. It can work as a Microsoft Visual Studio plug-in, with Microsoft Visual Basic, with IBM VisualAge for Java, or standalone. It is used to generate a stored procedure, which DB2 will build into an external C language load module without requiring the user to log on to TSO. The SPB supports the entire DB2 family from a single development environment. There are many options, and we will examine each of them.

Figure 8-2. Using SPB to Create Stored Procedures

Using SPB, you ...

Get DB2® Universal Database™ for OS/390™ v7.1 Application Certification Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.