Parameter Properties window: General tab

This tab has the following components:

Name Shows the name of the selected parameter.
Type Shows the type of object.
Procedure Shows the name and owner of the procedure to which the parameter belongs.
Data type Shows the data type of the parameter.
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.
- Return The return value. This parameter type only applies to functions.
- SQLSTATE The special SQLSTATE output parameter. This parameter is an OUT parameter that outputs the SQLSTATE value when the procedure ends. 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. See CREATE PROCEDURE statement.
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.
- In/out The parameter is a variable that provides a value to the function, and could be given a new value by the function.