Subject | Re: [ib-support] UDF migration |
---|---|
Author | Helen Borrie |
Post date | 2003-05-15T07:31:21Z |
At 08:11 PM 14/05/2003 +0100, you wrote:
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
>Unfortunately they were defined with a full path so after migration theyYou could try
>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
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