Subject | How to declare UDF ? |
---|---|
Author | Vince Ieraci |
Post date | 2007-04-20T11:18:15Z |
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,
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,