Scalar User-defined Functions (UDFs)
Custom scalar functions can be created for use in queries to extend database functionality. The CREATE FUNCTION statement defines a function and DROP FUNCTION removes it.
Functions can be written in SQL, JavaScript, and Python. The implementation languages (other than SQL) must be specified on the installation configuration parameter udf_languages in config.dat.
For details, see Scalar User-defined Functions, CREATE FUNCTION, and DROP FUNCTION in the SQL Reference Guide.
Note: SQL and JavaScript UDFs are a development release. Please work with Actian Support before using such UDFs in a production environment.
Python UDFs are in beta status and disabled by default. Do not use Python UDFs in production until Actian certifies this functionality as production ready. Please contact Actian Support if you are interested in beta testing.
Last modified date: 08/14/2024