SQLJ Procedure Properties

Use the SQLJ procedure Properties window to access and modify SQLJ procedures.

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

Pages Properties
General
  • Name
  • Type
  • Database
  • Owner
  • Creation date
  • Group number
SQL SQL statements for creating the procedure
Parameters
  • Name
  • Type
  • Mode – indicates whether it is an input or an output parameter
  • Order of all the procedure parameters – a numeric value that indicates the place of the parameter in the list of parameters

To change the parameters, change the definition of the stored procedure by dropping and re-creating the procedure.

Permissions Grant and revoke permissions on a procedure to users, groups, or roles. Choose the Grant option to allow the grantee to further grant permissions to other users.
Referenced By
  • Name
  • Type
  • Owner
  • Properties of objects
References
  • Name
  • Type
  • Owner
  • Properties of objects that the procedure references
Related tasks
Creating a SQLJ Function
Creating a SQLJ Procedure
Related reference
SQLJ Function Properties