Subject Re: [ib-support] UDF migration
Author Helen Borrie
At 08:11 PM 14/05/2003 +0100, you wrote:
>Unfortunately they were defined with a full path so after migration they
>don't work. Deleting/updating them would be difficult due to dependancies.
>Is there a way I can (perhaps updating a system table) change the path

You could try
update rdb$functions
set rdb$module_name='udflib'
where rdb$entrypoint='fn_whatever'

Be sure that you get the case correct for the positioning criterion, i.e.
as it was declared in the original database, since rdb$entrypoint is a
char(31).

You'll need totally exclusive access and no GUI admin tool running, that
queries the system tables. Use isql locally. Remember to shut down and
start up the server afterwards.

heLen