IBM Books

Application Development Guide

Stored Procedures

  • Stored Procedure Overview
  • Advantages of Stored Procedures
  • Writing Stored Procedures
  • Client Application
  • Allocating Host Variables
  • Calling Stored Procedures
  • Running the Client Application
  • Stored Procedure on the Server
  • Registering Stored Procedures
  • Variable Declaration and CREATE PROCEDURE Examples
  • SQL Statements in Stored Procedures
  • Restrictions
  • Return Values
  • Example OUT Stored Procedure
  • OUT Client Description
  • Example Client Application: Outcli.java
  • OUT Stored Procedure Description
  • Example Stored Procedure: Outsrv.sqlj
  • Code Page Considerations
  • C++ Consideration
  • Graphic Host Variable Considerations
  • Multisite Update Consideration
  • Building the Stored Procedure
  • Client Application
  • Stored Procedure
  • NOT FENCED Stored Procedures
  • Returning Result Sets from Stored Procedures
  • Resolving Problems
  • Overview of Stored Procedure Builder
  • What is SPB?
  • Advantages of Using SPB
  • Creating New Stored Procedures
  • Working with Existing Stored Procedures
  • Creating SPB Projects
  • Debugging Stored Procedures

    • [ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

    [ DB2 List of Books | Search the DB2 Books ]