At 11:05 AM 8/01/2005 +0000, you wrote:

>Hello,
>
>I executed these sql scripts to register UDF librarys
>fbudf.sql
>ib_udf.sql
>and was expecting to work these udf for all databases, but when I
>created new database these UDF were not working. Should I register
>UDF for each database

Yes

>or there are other way to make firebird work
>with UDF without registering each time when I create DB?

No.

>
>Should I register just these UDF that I use in my querys?

I have a single script for all of the UDFs that I use. In total, the
declarations are perhaps 10% of the possible declarations in the three main
libraries. It includes a number of re-declarations of various string
functions so that I can minimise the sizes of memory allocated for strings.

>If I register all functions that are in fbudf.sql ib_udf.sql, will
>it make no impact for performace?

No, it shouldn't impact performance. It's really up to you what you would
like to have available.

./hb