SQLJ Function Properties

Use the SQLJ Function Properties window to access and modify SQLJ functions.

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

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