SourcePro : DB Access Module for DB2 CLI User’s Guide : Technical Information : Stored Procedures : Instantiating an RWDBStoredProc Using Schema Data
Instantiating an RWDBStoredProc Using Schema Data
The member functions:
 
RWDBDatabase::storedProc(RWCString, RWDBSchema, RWDBColumn)
RWDBDatabase::storedProc(RWCString, RWDBConnection, RWDBSchema,
 
RWDBColumn)
increase the performance of stored procedures by eliminating the usual parameter fetch required for instantiation. The schema must include the RWDBColumn::ParamType of each parameter in the stored procedure. The column is ignored as all SQL procedures in DB2 CLI return an integer. For example, the code in Creating Stored Procedures uses the schema params to create the stored procedure; params could also be used to instantiate an RWDBStoredProc.