Stored procedures are encapsulated by class RWDBStoredProc. The DB2 CLI access library implementation of stored procedures is subject to the same restrictions applied to DB2 stored procedures.
Due to the way stored procedures are implemented on DB2 Common Server, the DB2 CLI access library implements only a subset of the RWDBStoredProc functionality declared in the DBTools.h++ core. In particular, the following two functions are not implemented:
RWDBDatabase::createProcedure()
and
RWDBStoredProc::dropProcedure(),
These functions return a status of RWDBStatus::notSupported. Each stored procedure must be created and registered with the DB2 Common Server separately before it is invoked through the DB2 CLI access library. Refer to DB2's online documentation for details.
RWDBStoredProc::text() is not supported and returns an empty RWCString.
Stored procedures in DB2 don't support return values. The function RWDBStoredProc::returnValue() returns a NULL RWDBValue.
The member function:
RWDBDatabase.storedProc(RWCString, RWDBConnection, RWDBSchema)
does not implement an instantiation of RWDBStoredProc that increases performance at this time. Currently, the member function is implemented identically to:
RWDBDatabase.storedProc(RWCString, RWDBConnection)
©Copyright 2000, Rogue Wave Software, Inc.
Contact Rogue Wave about documentation or support issues.