Execute 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.