User-defined routine (Server)
A user-defined routine (UDR) is a routine that you can start within an SQL statement or another UDR. UDRs are building blocks for the development of DataBlade modules.
Possible uses for a UDR are:
- Support function for an opaque data type
- Cast function to cast data from one data type to another
- End-user routine for use in SQL statements
- Operator function to implement an operation on a particular data type
When you write a UDR in an external language (a language other than SPL), the UDR is called an external routine. An external routine that is written in the C language is called a C UDR. A C UDR uses the server-side implementation of the DataBlade API to communicate with the database server.
For general information about UDRs, see the HCL Informix User-Defined Routines and Data Types Developer's Guide.