can i create udf this way ?

[heming_g@hotmail.com]

i directly copy the file compiled in another machine to sqllib/function
, and run the createfun.sql

but when i run it .. it throw sql0444n

[heming_g@hotmail.com]

Re: can i create udf this way ?

SQL0444N Routine "xxxx" is implemented with code in library or path
".../sqllib/function/xxxx" function "xxxx" which cannot be accessed .
Reason code : 5

[Kiran Nair]

Re: can i create udf this way ?

What are the arcietectures of source and traget machine. Its better you
compile the code in target machine.

heming_g@hotmai l.com wrote:
[color=blue]
> SQL0444N Routine "xxxx" is implemented with code in library or path
> ".../sqllib/function/xxxx" function "xxxx" which cannot be accessed .
> Reason code : 5[/color]

[heming_g@hotmail.com]

Re: can i create udf this way ?

it's the same ... aix 5.0

now it's ok .. i complie it at target machine , after its compiler is
fixed ..

but .. i still wonder wheather there are any chances to make it work
without compile it .

[Serge Rielau]

Re: can i create udf this way ?

heming_g@hotmai l.com wrote:[color=blue]
> it's the same ... aix 5.0
>
> now it's ok .. i complie it at target machine , after its compiler is
> fixed ..
>
> but .. i still wonder wheather there are any chances to make it work
> without compile it .
>[/color]
As long as the machines are compatible it should work.
My guess is you were short some permissions.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab