There are two mechanisms for creating user-defined functions in Adaptive Server IQ. You can use the SQL language to write the function, or you can use Java.

User-defined functions are processed by the Adaptive Server Anywhere portion of the product. They do not take advantage of the performance features of Adaptive Server IQ. Queries that include user-defined functions will run at least 10 times slower than queries without them.

In very few cases, differences in semantics between ASA and ASIQ can produce different results for a query if it is issued in a user-defined function. For example, IQ treats the CHAR and VARCHAR data types as distinct and different, while Anywhere treats CHAR data as if it were VARCHAR.

User-defined functions in SQL

You can implement your own functions in SQL using the CREATE FUNCTION statement. The RETURN statement inside the CREATE FUNCTION statement determines the data type of the function.

Once a SQL user-defined function is created, it can be used anywhere a built-in function of the same...