Managing UDFs

UDFs provide a way to implement custom business logic that becomes part of the database. Like functions in other programming languages, UDFs accept parameters and return scalar values. PL/MX UDFs are also true stored functions in that both the source and object code are stored and maintained completely within the database. For that reason, you may see UDFs sometimes referred to as stored functions. SQL/MX Release 3.5 on L17.02 and later versions support the creation, use, and management of UDFs.

UDFs are specifically a SQL/MX feature. The use of UDFs with SQL/MP tables, aliases, or NAMETYPE NSK, is not supported and the behavior undefined.