WebSphere Adapter for JDBC
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 Create, Update, Retrieve, Delete or RetrieveAll operations. The column names for SQL statements are derived from an attribute’s application-specific information. 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.
Last updated: Tue 12 Dec 2006 03:32:39
(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)