Scalar Function Properties

Use the scalar function properties wizard to access and modify information on stored procedures.

Click your scalar function and select Properties to initiate the Properties wizard.

Wizard Option Scalar Function Properties
General
  • View the name, type, database, owner, and creation date and group number of the function.
SQL
  • View the SQL statements for creating the function.
Parameters
  • View the name, type, mode, and order of all the function parameters. The mode value indicates whether it is an input or an output parameter. The order is a numeric value that indicates the place of the parameter in the list of parameters.
  • To change the parameters, change the definition of the function by dropping and re-creating the function.
Related tasks
Creating a Scalar Function
Creating a SQLJ Function