Scalar Function Properties

Use the Scalar Function Properties window to access and modify information.

Click the Name field of the scalar function, then click the drop-down arrow and select Properties.

Pages Properties
  • Name
  • Type
  • Database
  • Owner
  • Creation date
  • Group number
SQL The SQL statements for creating the function.
  • Name
  • Type
  • Mode – indicates whether it is an input or an output parameter
  • Order – 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.

Permissions Grant and revoke execute permission on a scalar function to users, groups, or roles.
Related tasks
Creating a Scalar Function
Creating a SQLJ Function