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 of the procedure the parameter belongs to, with the name of the procedure's owner in parentheses.

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.
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.