SQLJ Function Properties

Use the SQLJ function properties wizard to access and modify information on SQLJ functions.

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

Wizard Option SQLJ 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 SQLJ Function
Creating a SQLJ Procedure
Related reference
SQLJ Procedure Properties