From: Ian on
uwcssa(a)gmail.com wrote:
>
> SO... I have no clue what to do next...
> Thanks for your help again....
>

Out of curiosity, what is the create_time in SYSCAT.FUNCTIONS for these
objects? Is it in the future?


From: Serge Rielau on
Do you have distinct types? Are these cast functions?
Or are these really METHODS in a structured type?

Cheers
Serge


--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
From: Lennart on
uwcssa(a)gmail.com wrote:
> I guess my problem is more serious than i once thought. I have
> tried all possible means as you guys suggested, so here are them all:
>
> db2 => select funcschema, funcname, specificname from syscat.functions
> where funcschema='DEDEHAAN'
>
> FUNCSCHEMA FUNCNAME SPECIFICNAME
> -------------------------------------------------------------------------------------
> DEDEHAAN SUMSALARIES SQL070515104729271
> DEDEHAAN DEPTSALARIESF SQL070515141344272
>
> 2 record(s) selected.
>
>
> db2=> drop function DEDEHAAN.sumsalaries
> SQL0658N The object "DEDEHAAN.SUMSALARIES" cannot be explicitly
> dropped.
> SQLSTATE=42917
>
> db2 => drop specific function "DEDEHAAN"."SQL070515104729271"
> SQL0658N The object "DEDEHAAN.SUMSALARIES" cannot be explicitly
> dropped.
> SQLSTATE=42917
>

Can you post the code for DEDEHAAN.sumsalaries? If its an sql function
you can find it in syscat.functions (body?)

/Lennart

[...]
From: Lennart on
Lennart wrote:
[...]
>
> Can you post the code for DEDEHAAN.sumsalaries? If its an sql function
> you can find it in syscat.functions (body?)
>

and deptsalaries as well


> /Lennart
>
> [...]
From: Serge Rielau on
I think this should be a PMR.
A db2trc should be run to find out what DB2 is upset about.

Cheers
Serge


--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab