AV | Scalar User-defined Functions (UDFs)

SQL Language Guide > Elements of SQL Statements > Scalar User-defined Functions (UDFs)

Was this helpful?

Scalar User-defined Functions (UDFs)

Custom scalar functions can be created for use in queries to extend database functionality. Use the CREATE FUNCTION statement to define a function and the DROP FUNCTION statement to remove it. Functions can be written in SQL, JavaScript, and Python. UDFs are supported for X100 tables only.

Note: 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: 01/04/2024