Executing the User-Defined Routine

After you register a UDR as an external routine in the database, the UDR can be invoked in SQL statements such as:

• In the select list of a SELECT statement
• In the WHERE clause of a SELECT, UPDATE, or DELETE statement
• With the EXECUTE PROCEDURE or EXECUTE FUNCTION statement

The routine manager of the database server handles the execution of the UDR. For more information about the routine manager, see the IBM Informix: User-Defined Routines and Data Types Developer's Guide.