Object creation

[chettiar]

Hi,

I am trying to create a function in db2. The function is getting
created successfully, but when I query the syscat.function s, 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

[jefftyzzer]

Re: Object creation

Hi, Chettiar:

A few things:

1. How are you querying syscat.function s, 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.function s, 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