Object creation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chettiar - 30 Oct 2006 13:42 GMT

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

Reply to this Message

jefftyzzer - 30 Oct 2006 19:40 GMT

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

> Hi,
>
[quoted text clipped - 6 lines]
>
> chettiar

Reply to this Message