Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » Context-Sensitive Help » SQL Anywhere plug-in help » Introduction to SQL Anywhere properties windows

 

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.

 See also