SAParam::ParamDirType

SAParamDirType_t ParamDirType( ) const;

Returns direction type of parameter (input, output, etc.).

Return value

One of the following SAParamDirType_t enum values:

• SA_ParamInput    Input parameter.
• SA_ParamInputOutput    Input/output parameter.
• SA_ParamOutput    Output parameter.
• SA_ParamReturn    Returning parameter.

Remarks

Usually the Library automatically detects parameter's direction type and implicitly creates an appropriate SAParam object. But not all of DBMS clients/servers provide complete parameters information. In that situation programmer need to describe parameter's direction type explicitly. See Server specific notes for details. 

Server specific notes

DBMS client	Specific information
Oracle	No specific information.
SQL Server	No specific information.
Sybase	Sybase ASE server does not provide information about parameter's direction type, that's why SQLAPI++ Library defines all parameters (except status result code) as input (SA_ParamInput). If you have input-output parameters in the procedure you have to call SAParam::setParamDirType method for these parameters before command execution and set parameter's direction type explicitly. You shouldn't call this method for procedure status result code because it is detected correctly (as SA_ParamReturn) by the Library. There is no need to call this method for Sybase ASA because all parameters are detected correctly automatically (including the direction type).
DB2	No specific information.
Informix	No specific information.
InterBase	No specific information.
SQLBase	No specific information.
MySQL	No specific information.
PostgreSQL	No specific information.
ODBC	No specific information.

See also

setParamDirType

SAParamDirType_t enum

Problems and Questions

If you haven't found the answer to your questions or have some problems on using the Library, please, send e-mail to howto@sqlapi.com.