The ITRoutineManager class
Base class: ITErrorManager
This functionality provided by this class is only supported with HCL Informix® databases.
The ITRoutineManager class provides an alternative way to execute server routines. When using ITRoutineManager, a connection does not have to be checked out to get or execute a routine (and a value object, therefore, can use it), and the execution of the routine commences faster (since there is no SQL to parse). See The ITConnection class for information about connection checkout.
This class provides the following methods.
Method | Description |
---|---|
ITRoutineManager(ITConnection &) | Creates a Routine Manager for the specified connection. |
ITBool GetRoutine(const ITString & signature) | Gets the descriptor for the registered routine
from the server so the routine can be executed later by ExecForValue(). Returns TRUE if
it gets the routine descriptor, FALSE otherwise. |
const ITTypeInfo *ResultType() const | Returns a pointer to an ITTypeInfo instance that
encapsulates the type of the return value of the routine. It returns NULL if
did not get the routine. |
int NumParams() const | Returns the number of parameters the routine accepts, -1 if
did not get the routine. |
const ITTypeInfo *ParamType(int paramno) const | Returns a pointer to an ITTypeInfo instance that
encapsulates the type of the specified parameter. It returns NULL if
did not get the routine or if the argument is out of bounds. |
ITValue *Param(int paramno) const | Returns a pointer to the parameter value object, NULL if
did not get the routine or if the argument is out of bounds. |
ITBool SetParam(int paramno, ITDatum *pdatum) | Sets the parameter value object for a specified
parameter index to the pdatum. Returns TRUE on success, FALSE if
did not get the routine or if the parameter is out of bounds, or the
ITDatum is not of the same type as the corresponding routine parameter
type. |
ITValue *ExecForValue(ITEssential **outerunkn = NULL) | Executes the routine with the set parameters. Returns
a pointer to the ITValue interface of the value object, instantiated
for the return value. Returns NULL if did not get the routine
or if execution failed. |