当前位置: 代码迷 >> DB2 >> SQLSTATE=42723解决方法
  详细解决方案

SQLSTATE=42723解决方法

热度:7718   发布时间:2013-02-26 00:00:00.0
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
该模式下已经存在了同名的,删除后再建,或者换名字。
  相关解决方案