求助db2 drop table不能解决

雪刃狼 发表于 2010-10-20 10:08

在执行db2 drop table XXXX时，出现以下问题，无法删除表，请问大家如何解决该问题，谢谢
DB21034EThe command was processed as an SQL statement because it was not a
valid Command Line Processor command.During SQL processing it returned:
SQL0478NDROP or REVOKE on object type "TABLE" cannot be processed because
there is an object "LOAN.SQL100928145954400", of type "FUNCTION", which
depends on it.SQLSTATE=42893

wolfop 发表于 2010-10-20 12:09

先删除那个function LOAN.SQL100928145954400

雪刃狼 发表于 2010-10-20 16:59

解决了，主要是有视图和存储过程关联起来了。谢谢楼上的回答，虽然不对。

_北南_ 发表于 2010-10-21 09:30

a function -> {something else | ... ->} -> this table

study123 发表于 2010-11-16 23:06

阁下是怎么解决的吗？
能否贴出来呢？
谢谢！

页: [1]

Chinaunix's Archiver

求助db2 drop table不能解决