Scalar and Aggregate UDFs

Scalar and aggregate user-defined functions return a single value to the calling environment.

You can install SAP Sybase IQ in a wide variety of configurations. UDFs must be easily installed within this environment, and must be able to run within all supported configurations. The SAP Sybase IQ installer provides a default installation directory, but allows users to select a different installation directory. UDF developers should consider providing the same flexibility when installing the UDF libraries and associated SQL function definition scripts.

• Scalar and Aggregate UDF Restrictions
  External C/C++ scalar and aggregate user-defined functions have some restrictions.
• Creating a Scalar or Aggregate UDF
  Learn how to create and configure external C or C++ scalar and aggregate user-defined functions.
• Calling Scalar and Aggregate UDFs
  You can use a user-defined function, subject to permissions, any place you use a built-in nonaggregate function.
• Scalar and Aggregate UDF Calling Patterns
  Calling patterns are steps the functions perform as results are gathered.