Library Version (extfn_get_library_version)
Use the extfn_get_library_version method to extract the library version from the current multiplex node. The server considers partitioning a query across multiplex nodes only if the installed library is compatible with the other nodes.
License Information (extfn_get_license_info)
If you are a Sybase design partner, implement the extfn_get_license_info library-level function to enable the server to obtain licensing information from a v4 UDF.
Testing User-Defined Functions
After UDF external code has been coded, compiled and linked, and the corresponding SQL functions and stored procedures have been defined, the UDFs are ready to be tested.
Modifying the UDF at Runtime
Many SAP Sybase IQ installations are in mission-critical environments, where customers require an extremely high level of availability. System Administrators must be able to install and upgrade UDFs with little or no impact to the SAP Sybase IQ server.
Dropping User-Defined Functions
Once you create a user-defined function, it remains in the database until it is explicitly removed. Only the owner of the function or procedure, or a user with the DROP ANY PROCEDURE or DROP ANY OBJECT system privilege, can drop a function or procedure from the database.
Created May 23, 2013. Send feedback on this help topic to Technical Publications:
pubs@sybase.com