Get Param Type

Retrieves the in/out type of the current stored-procedure parameter.

Inputs

CwDBStoredProcedureParam
The stored-procedure parameter (a CwDBStoredProcedureParam object) whose in/out type you want to retrieve.

Output

Returns the in/out type of the associated stored-procedure parameter as an integer constant.

Notes

The Get Param Type function block returns the in/out parameter type of the current stored-procedure parameter. The in/out parameter type indicates how the stored procedure uses the parameter. The CwDBStoredProcedureParam class represents each in/out type as a constant, as Table 73 shows.

Table 73. Parameter in/out types (Get Param Type function block)
Parameter in/out type Description In/out type constant
IN parameter An IN parameter is input only; that is, the stored procedure accepts its value as input but does not use the parameter to return a value. PARAM_IN
OUT parameter An OUT parameter is output only; that is, the stored procedure does not read its value as input but does use the parameter to return a value. PARAM_OUT
INOUT parameter An INOUT parameter is input and output; that is, the stored procedure accepts its value as input and also uses the parameter to return a value. PARAM_INOUT

Related information

This function block is based on the CwDBStoredProcedureParam.getParamType() method. For more information, see getParamType().

Copyright IBM Corp. 2004, 2005