Application performance can be improved with these enhancements to the stored procedure capabilities of DB2 Universal Database.
Stored Procedure Builder has been enhanced to simplify the process of building your stored procedures and also to make it easier to debug and deploy them in your enterprise:
For more information on the Stored Procedure Builder see the Online Help.
DB2 now delivers nested stored procedure support that not only simplifies the migration of applications from other database vendors, but also allows application developers to use and exploit stored procedures in a more effective way. See the Application Development Guide for more information.
SQL Procedure Language support is now available for DB2 on Windows, OS/2, and UNIX, in addition to DB2 Universal Database for OS/390 and AS/400. It supports building DB2 stored procedures that employ SQL in a manner consistent with the Persistent Stored Module definition of the ANSI SQL99 standard. See the Application Development Guide and the Application Building Guide for more information.
DB2 Universal Database now enables you to write a Visual Basic OLE automation stored procedure and deploy it on a DB2 for Windows 32-bit operating system server. You can specify OLE as the language in which the stored procedure is implemented and call it from a client application written in any of the languages supported by DB2. See Native OLE DB Support for more information on DB2 OLE support.
Stored procedures can now be called from the command line processor (CLP), using the CALL command. See the SQL Reference, Volume 1 for more information.
An enhanced set of stored procedure samples is available with the Application Development Client. The samples are written using embedded SQL in C/C++, CLI in C, JDBC in Java, and SQL procedures. They demonstrate the capability of client applications in one language to call a stored procedure written in another language. Separate source files for CREATE PROCEDURE statements, client applications, stored procedures, and DROP PROCEDURE statements make it easy to copy and modify the sample code to create your own stored procedures.
With the Java class loader, DB2 Universal Database enables you to improve the performance of your Java stored procedures and increase the availability of your production servers. The Java class loader enables you to perform online replacement of your Java stored procedure classes. When you issue the CALL SQLJ.REFRESH_CLASSES() statement, DB2 continues to run, and the Java Virtual Machine (JVM) remains loaded in memory, ready to execute the refreshed stored procedure classes. Stored procedures can use the new classes without the need to stop the database manager. See the Application Development Guide for more information.