读书人

SQLSTATE=42723解决方法

发布时间: 2012-02-12 17:16:33 作者: rapoo

SQLSTATE=42723
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0454N The signature provided in the definition for routine
"LY.DROP_COMMON_YYYYMMDD_TABLE" matches the signature of some other routine
that already exists in the schema or for the type. LINE NUMBER=52.
SQLSTATE=42723

[解决办法]
1.命令敲错了。
2.是在create时报的错吗?
matches the signature of some other routine that already exists in the schema or for the type
该模式下已经存在了同名的,删除后再建,或者换名字。

读书人网 >IBM DB2

热点推荐