473,836 Members | 1,490 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

can not drop table but can not find dependence either

I try to drop a table as:
drop table sch.tab;
I got: During SQL processing it returned:
SQL0478N The object type "TABLE" cannot be dropped because there is
an object "sch.SQL0705151 04729271", of type "FUNCTION", which depends
on it. SQLSTATE=42893

Then I tried to do
>drop function sch.SQL07051510 4729271
but it says this is not defined. Actually, I tried to search that
function with
SELECT tabname FROM SYSCAT.TABLES
union SELECT procname FROM SYSCAT.procedur es
union SELECT funcname FROM SYSCAT.function s
union SELECT pkgname FROM SYSCAT.packages
but failed to find that function name. I also search dependency by:
select bschema, bname, dschema, dname from sysibm.sysdepen dencies;
I found:
BSCHEMA BNAME DSCHEMA DNAME
sch tab sch SQL070515104729 271
What does this mean to me? since I can not find what the heck is the
object "SQL07051510472 9271"
Thanks!

May 17 '07
15 10839
Ian
uw****@gmail.co m 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.FUNCTION S for these
objects? Is it in the future?
May 23 '07 #11
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
May 23 '07 #12
uw****@gmail.co m 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.function s
where funcschema='DED EHAAN'

FUNCSCHEMA FUNCNAME SPECIFICNAME
-------------------------------------------------------------------------------------
DEDEHAAN SUMSALARIES SQL070515104729 271
DEDEHAAN DEPTSALARIESF SQL070515141344 272

2 record(s) selected.
db2=drop function DEDEHAAN.sumsal aries
SQL0658N The object "DEDEHAAN.SUMSA LARIES" cannot be explicitly
dropped.
SQLSTATE=42917

db2 =drop specific function "DEDEHAAN"."SQL 070515104729271 "
SQL0658N The object "DEDEHAAN.SUMSA LARIES" cannot be explicitly
dropped.
SQLSTATE=42917
Can you post the code for DEDEHAAN.sumsal aries? If its an sql function
you can find it in syscat.function s (body?)

/Lennart

[...]
May 24 '07 #13
Lennart wrote:
[...]
>
Can you post the code for DEDEHAAN.sumsal aries? If its an sql function
you can find it in syscat.function s (body?)
and deptsalaries as well

/Lennart

[...]
May 24 '07 #14
Here is the function definition:
CREATE FUNCTION DEPTSALARIESF(D EPT CHAR(3))
RETURNS TABLE(SALARY DECIMAL(9,2))
LANGUAGE SQL
RETURN
SELECT salary
FROM employee
WHERE workdept = dept
CREATE FUNCTION SUMSALARIES(DEP T CHAR(3))
RETURNS DECIMAL(9,2)
LANGUAGE SQL
RETURN
SELECT sum(salary)
FROM employee
WHERE workdept = dept

Here is the definition of the table:
db2 =describe table dedehaan.employ ee;
Column Type Type
name schema name Length
Scale Nulls
------------------------------ --------- ------------------ --------
----- -----
EMPNO SYSIBM CHARACTER
6 0 No
FIRSTNME SYSIBM VARCHAR
12 0 No
MIDINIT SYSIBM CHARACTER
1 0 No
LASTNAME SYSIBM VARCHAR
15 0 No
WORKDEPT SYSIBM CHARACTER
3 0 Yes
PHONENO SYSIBM CHARACTER
4 0 Yes
HIREDATE SYSIBM DATE
4 0 Yes
JOB SYSIBM CHARACTER
8 0 Yes
EDLEVEL SYSIBM SMALLINT
2 0 No
SEX SYSIBM CHARACTER
1 0 Yes
BIRTHDATE SYSIBM DATE
4 0 Yes
SALARY SYSIBM DECIMAL
9 2 Yes
BONUS SYSIBM DECIMAL
9 2 Yes
COMM SYSIBM DECIMAL
9 2 Yes
I can not drop the table, nor any of the two functions defined on it.
there is no
user-defined data structure in the functions, as i can see....
>
Can you post the code for DEDEHAAN.sumsal aries? If its an sql function
you can find it in syscat.function s (body?)

and deptsalaries as well
/Lennart
[...]- Hide quoted text -

- Show quoted text -

May 24 '07 #15
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
May 24 '07 #16

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
1444
by: Leslie | last post by:
I have 2 dlls and they reference each other, thus causing the circular dependence error. I have read about other cases and people say use Interfaces to solve the problem with the shared methods. My case is getting the error, not because methods need shared, but because forms need shared. Example: A.DLL has form TestA1, TestA2 B.DLL has form TestB TestA1 navigates to display TestB, thus A.DLL needs to reference B.DLL so the form will...
5
3020
by: simon_s_li | last post by:
Hi, I have 5 fields in line where I need to drag and drop the text from one field to another field and then all the fields need to re-order themselves. So for instance if I drag the text in field 1 to field 3, then field 2 text and field 3 move to field 1 and field 2. I add the new order of text into an array so when the onDragEnd event
10
26149
by: BuddhaBuddy | last post by:
Platform is DB2/NT 7.2.9 The table was created like this: CREATE TABLE MYTEST ( MYTESTOID bigint not null primary key, FK_OTHEROID bigint not null references other, FK_ANOTHEROID bigint not null references another, FK_LASTLYOID bigint not null references lastly, unique (FK_OTHEROID,FK_ANOTHEROID))
2
2479
by: tpaulson | last post by:
I have a couple of DIV's that I hide/display based on radio buttons. On the DIV's, I have multiple drop down boxes. The source shows that they are populated, but I can't make them drop down. Only click on the Unplatted Radio button, the rest isn't functional, yet. Any ideas how to make these drop down in FF. This works in IE. Here is the code: <HTML> <HEAD> <TITLE>Door County Register of Deeds - Tract Inquiry</TITLE>
2
3343
by: Timbo | last post by:
Hi there, I’m not used to working in VB and I think this situation calls for excactly that. I use Access 97 SR-2. My first table is a table containing all the Tickets I got. The field ”Ticket” is simply a ticket-number. I’ve made a form in which I am to choose an existing Ticket and write a description for it pluss other things. The description to these Tickets are stored in another table called ”LogBook”. I then made a query on all of...
3
6687
by: Rahul B | last post by:
Hi, I have a user UCLDEV1 which is a part of staff and a group(db2schemagrp1) to which i have not given any permissions. The authorizations of that user are shown as db2 =get authorizations Administrative Authorizations for Current User
5
13822
by: Romulo NF | last post by:
Greetings, I´m back here to show the new version of the drag & drop table columns (original script ). I´ve found some issues with the old script, specially when trying to use 2 tables with drag&drop on the same page (which was not possible). Now i´ve a new concept of the script, more object oriented. I´ve also commented the whole code so you guys can easier understand it engine. What exactly we need when trying to make a column drag &...
4
12926
by: Joseph | last post by:
Can i drop a cloumn from a table in DB2 for Z/OS?
10
49622
by: Dean | last post by:
My client has a db I am working that uses temp tables. During an update procedure, I had the code If fTableExists(tempTblName) = True Then DoCmd.DeleteObject acTable, tempTblName Then I thought of using: If fTableExists(tempTblName) = True Then CurrentDb.Execute "DROP TABLE " & tempTblName Is there an advantage to either? What really be cool is DROP TABLE deleted the table and I didn't have to compact the db so much.
0
10834
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10541
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10584
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10248
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6976
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5645
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5817
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4006
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3108
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.