WebSphere Adapter for JDBC
The Execute operation is used to run stored procedures. The enterprise service discovery wizard generates the required stored procedure business object that corresponds to the stored procedure definition in the database. The adapter uses the Execute operation to process the stored procedure business object.
The following information provides a simple example of a stored procedure, the business object that is constructed from it, and the steps the adapter uses to process the stored procedure business object with an Execute operation.
PROCEDURE testSP(IN int x,INOUT VARCHAR(10) msgSTR, OUT int status, OUT struct outrec, OUT array retArr)(Procedure returns two resultsets)
BOLevel ASI SPName=testSP ResultSet=true MaxNumberOfResultSets=2 ReturnValue = propName (if function). Will be property name corresponding to the child business object if returned value is complex type (array/struct/resultset) Defined only if it is a Function Properties x Type=IP msgStr Type=IO status Type=OP outrec Type OP - Child BO for outrec, ASI ChildBOType = struct retarr Type OP - n cardinality child BO for retArr, ASI ChildBOType = array childBOName1 - Child BO for 1st resultset, ASI ChildBOType = resultset childBOName2 - Child BO for 2nd resultset, ASI ChildBOType = resultset
Last updated: Tue 12 Dec 2006 03:32:38
(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)