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.
