At 03:27 AM 26/09/2006, you wrote:

>Hi,
>
>In the file ib_udf.sql the external lower function is declared as:
>
> DECLARE EXTERNAL FUNCTION lower
> CSTRING(255)
> RETURNS CSTRING(255) FREE_IT
> ENTRY_POINT 'IB_UDF_lower' MODULE_NAME 'ib_udf';
>
>I thought that this was enough, but I can't use the lower function.
>I've resolved this including this declaration on the database file, is
>this really necessary?

Yes indeed. Any UDF you are going to use has to be declared to the
database. The ".SQL" files are there for your convenience, so you
can copy the declarations of any functions you want (or run them as
scripts, if you decide you want all of them).

./heLen