Information about user-defined routines

The database server stores information about UDRs in the following system catalog tables:
  • The sysprocedures system catalog table contains information about the UDR, such as its name, owner, and whether it is a user-defined function or user-defined procedure.
  • The sysprocbody system catalog table contains the actual code of SPL routines.
  • The sysprocauth system catalog table contains information about which users of the database server can execute a particular UDR.

The CREATE FUNCTION and CREATE PROCEDURE statements do not provide the actual code that makes up the external routine. Instead, they store information about the external routine (including the name of its executable file) in the sysprocedures system catalog table. Therefore, unlike SPL routines, the code for the body of an external routine does not reside in the system catalog of the database.

The database server stores information about external languages that it supports for UDRs in the following system catalog tables:
  • The sysroutinelangs system catalog table contains information about the external languages.
  • The syslangauth system catalog table contains information about which users of the database server can use a particular external language.

For more information, see Create an external-language routine.