WebSphere Adapter for JDBC

Stored Functions overview

Stored functions are similar to stored procedures, except that they always return a value. For some databases, such as Oracle, you can define functions explicitly. For other databases, such as IBM® DB2®, stored procedures that return a value behave like functions.

A stored procedure call is run as follows:

call SPName (<parameter list>)

whereas a function call is run as follows:

? = call FunctionName (<parameter list>)

You specify the attribute that contains the returned value by using the ReturnValue business object application-specific information. For more information on ReturnValue, see "Application-specific information at the business-object level."


Terms of use |

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)