Nick Upson wrote:

> In article <3EC137B3.6030900@...>, Milan Babuskov wrote:
>
>>>I'm attempting to migrate a 4.2 interbase database, on IRIX, to Firebird on
>>>Linux (RH8)
>>>
>>>As the UDF libraries will be in a different location, what's the best way to
>>>migrate the UDF's. I can't just drop and recreate them as they are used by
>>>SP's.
>>
>>Which UDF libraries are you using?
>>
>>AFAIK, If it's just regular ib_udf, you don't have to "migrate" anything.
>
>
> It's the definitions within the database for each UDF, they have the path which
> will no longer exist
>

Well, when declaring UDS in Firebird, you don't have to put full path,
just library name, for example:

DECLARE EXTERNAL FUNCTION abs
DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'IB_UDF_abs' MODULE_NAME 'ib_udf';

This will look for library named: ib_udf, in default UDF folder, which
should be /opt/interbase/UDF/ on Red Hat.

See ib_udf.sql file in examples directory of your firebird installation.

--
Milan Babuskov
http://fbexport.sourceforge.net