User-defined functions use specific statements and functions.
Learn to create function prototypes, and the syntax and usage of
the statements.
External function prototypes
Define the API by a header file named extfnapiv3.h, in the subdirectory of your Sybase IQ installation directory. This header file handles the platform-dependent features of external function prototypes.
Finance specific functions
If you have RAP – The Trading Edition™: Enterprise, you can use these user-defined aggregate functions for financial analysis:
Managing external libraries
External libraries are loaded by the server the first time a UDF that requires it is invoked. A loaded library remains loaded by the server for the life of the server once it has been loaded after first being needed. It is not loaded when a CREATE FUNCTION call is made, nor is it automatically unloaded when a DROP FUNCTION call is made.
Controlling error checking and call tracing
The external_UDF_execution_mode option controls the amount of error checking and call tracing that is performed when statements involving external V3 user-defined functions are evaluated.
Created November 2, 2009. Send feedback on this help topic to Sybase Technical Publications:
pubs@sybase.com