Parameter property sheet: General tab

The General tab of the Parameter property sheet has the following components:

Name Shows the name of the selected parameter.
Type Shows the type of object
Procedure Shows the name of the procedure the parameter belongs to, with the name of the procedure's owner in parenthesis.
Data type Shows the data type of the parameter.
For a list of valid data types, see SQL Data Types.
Parameter type Shows the type of parameter. The parameter has one of the following types:
- Variable A normal procedure parameter.
- Result A column in a result set returned by the procedure.
- SQLSTATE The special SQLSTATE output parameter. This parameter is an OUT parameter that outputs the SQLSTATE value when the procedure ends.
  For more information about the SQLSTATE parameter, see CREATE PROCEDURE statement.
- SQLCODE The special SQLCODE output parameter. This parameter is an OUT parameter that outputs the SQLCODE value when the procedure ends.
  For more information about the SQLCODE parameter, see CREATE PROCEDURE statement.
- Return The return value. This parameter type only applies to functions.
Mode Shows the mode of the parameter. The mode has one of the following values:
- In The parameter is an expression that provides a value to the function.
- Out The parameter is a variable that could be given a value by the function.
- Inout The parameter is a variable that provides a value to the function, and could be given a new value by the function.