Stored Procedures and Functions

Use this page to view information about the stored procedures and functions in a database. Display and copy the SQL that was used to create them.

To display the SQL used to create a procedure or function, click the procedure or function in the list.

The page displays the following information about the procedures and functions in the database:

• Procedure or Function: A routine can be a function, which returns values, or a procedure, which does not.
• Owner
• Type: Procedure or Function
• Mode:
  • DBA
  • Owner
  • Protected
  • Restricted
  • Trigger
• Language: The language that the procedure or function is written in; for example, the Informix® Stored Procedure Language (SPL) or in an external language, such as C or Java™.
• Number of Arguments
• Parameter Types: Information describing the parameters of the procedure or function.
• Return Size (Bytes): The compiled size of the returned values in bytes.