Subject How to declare UDF ?
Author Vince Ieraci
Hi,

I have FB installed on OpenSUSE 10.2.
I want to declare some UDF's from the /opt/firebird/UDF/fbudf.so
shared library.

Question is how do I declare the functions in FB ?
I tried copying some text from the .sql file and running it in a
command window (FlameRobin)

DECLARE EXTERNAL FUNCTION lower
CSTRING(255)
RETURNS CSTRING(255) FREE_IT
ENTRY_POINT 'IB_UDF_lower' MODULE_NAME 'ib_udf';

but I get the error message "Token Unknown" which is referring to
"lower".

Do I need to compile the .so file first ?
How do I go about this ?
Thanks,