The types of user-defined functions (UDFs) available in SAP Sybase IQ.
| UDF Type | Description | Required Licence | See |
|---|---|---|---|
| UDF (SQL) | A user-defined function written in SQL. | none | Administration: Database > Create Procedures and Batches > Introduction to User-Defined Functions |
| Scalar C or C++ UDF | V3 external C or C++ procedure that operates on a single value. | IQ_UDF | Learning Roadmap: Types of External C and C++ UDFs |
| Scalar C or C++ UDF | V4 external C or C++ procedure that operates on a single value. | IQ_IDA | Learning Roadmap: Types of External C and C++ UDFs |
| Aggregate C or C++ UDF | V3 external C or C++ procedure that operates on multiple values. Aggregate UDFs are also sometimes known as UDAs or UDAFs. The context structure for coding aggregate UDFs is slightly different than the context structure used for coding scalar UDFs. | IQ_UDF | Learning Roadmap: Types of External C and C++ UDFs |
| Aggregate C or C++ UDF | V4 external C or C++ procedure that operates on multiple values. Aggregate UDFs are also sometimes known as UDAs or UDAFs. The context structure for coding aggregate UDFs is slightly different than the context structure used for coding scalar UDFs. | IQ_IDA | Learning Roadmap: Types of External C and C++ UDFs |
| Table UDF | External C or C++ procedure that produces a set of rows and can be used as a table expression in the FROM clause of a SQL statement | IQ_IDA | Learning Roadmap: Types of External C and C++ UDFs |
| Table parameterized function | A table UDF that accepts table (non-scalar) parameters in addition to scalar parameters, and can be executed in parallel over partitions of row-sets. Also known as table parameterized user-defined functions. | IQ_IDA | Learning Roadmap: Types of External C and C++ UDFs |
| Java scalar UDF | An out-of-process (external environment) scalar user-defined function implemented in Java code. | none | The Java External Environment |
| Java table UDF | An out-of-process (external environment) table UDF implemented in Java code. | none | The Java External Environment |