Creating a shared-object file
You create a shared-object file to hold the compiled UDRs. This file is in a directory on the server computer. Each UDR must have a unique name within the shared-object file.
About this task
On UNIX™ or Linux™ a shared-object file is often called a shared library. On Solaris systems, shared-object files have the .so file extension.
On Windows™ a shared-object file is called a dynamic link library (DLL). DLLs usually have the .dll file extension.
When the database server executes an SQL statement that contains a UDR, it loads in memory the shared-object file in which the UDR executable code is. It determines which shared-object file to load from the externalname column of the row in the sysprocedures system catalog table that describes the UDR. The CREATE FUNCTION or CREATE PROCEDURE statement creates a row for a UDR in sysprocedures when it registers the UDR.