Rational Developer for System z


Next >

Create, test, and deploy a DB2 SQL stored procedure

This tutorial teaches you how to create, test, and deploy a DB2® SQL stored procedure, which can improve application performance by reducing database access traffic. For each SQL statement, a database manager application must initiate a separate communication with DB2. Database performance is improved because the stored procedure runs the SQL statement on the server rather than on the client. In addition, DB2 stored procedures also help to centralize business logic by immediately making changes to a stored procedure available to all client applications.
A SQL stored procedure is a stored procedure where the source code is part of the CREATE PROCEDURE statement, or the stored procedure body.

Learning objectives

Upon successful completion of these exercises, you should be able to:
This tutorial should take approximately 60 minutes to finish. If you explore other concepts related to this tutorial, it could take longer to complete.

Skill level

Advanced

Audience

Database developers

System requirements

Prerequisites

In order to complete this tutorial, you should be familiar with the following concepts:
Next >

Terms of use | Feedback



This information center is powered by Eclipse technology. (http://www.eclipse.org)