Hi,

I am trying to create a function in db2. The function is getting
created successfully, but when I query the syscat.functions, i dont
find my function.

also when i try to recreate the function, it says similar object
already exists. Can some one please help me

chettiar

Hi, Chettiar:

A few things:

1. How are you querying syscat.functions, and can you reply to this
forum w/ the query?
2. It's recommended that you use syscat.routines (not that switching
will fix your current problem--it's an issue of view deprecation).
3. Can you also reply with the CREATE and DROP FUNCTION statements
you're using? I suspect it's an issue of destination schema.

Regards,

--Jeff

chettiar wrote:
> Hi,
>
> I am trying to create a function in db2. The function is getting
> created successfully, but when I query the syscat.functions, i dont
> find my function.
>
> also when i try to recreate the function, it says similar object
> already exists. Can some one please help me
>
> chettiar