Stored Procedure overview

A stored procedure is a group of SQL statements that form a logical unit and perform a particular task. A stored procedure encapsulates a set of operations or queries for the adapter to run on an object in a database server.

The adapter can use simple SQL statements for select, update, retrieve, delete or retrievall operations. The column names for SQL statements are derived from an attribute’s AppSpecificInfo property. The WHERE clause is constructed using key values specified in the business object. Each query spans one table only, unless posted to a view.

The adapter calls stored procedures in the following circumstances:

When it processes a hierarchical business object, the adapter can use a stored procedure to process the top-level business object or any of its child business objects. However, each business object or array of business objects must have its own stored procedure.


Terms of use |

Last updated: Thu Mar 23 13:24:31 2006

(c) Copyright IBM Corporation 2005.
This information center is powered by Eclipse technology (http://www.eclipse.org)