I am developing the SQL stored procedure using SPB(Stored Procedure Builder) on windows 2000 and DB2 v7.1. I found that I can't build the sql procedure again after I call it in the CLP.
I have finished to build the SQL stored procedure and then I call it in the CLP(Command Line Processor). But I found that the result is error, so I modified the SQL stored procedure using SPB and then builded it. The messages of SPB is:
DB2ADMIN.PROC3 - Failed to drop the stored procedure.
DB2ADMIN.PROC3 - [IBM][CLI Driver][DB2/NT] SQL0970N The system attempted to write to a read-only file. SQLSTATE=55009
DB2ADMIN.PROC3 - Create stored procedure returns -454.
DB2ADMIN.PROC3: [IBM][CLI Driver][DB2/NT] SQL0454N The signature provided in the definition for routine "PROC3" matches the signature of some other routine that already exists in the schema or for the type. SQLSTATE=42723
DB2ADMIN.PROC3 - Build failed.
DB2ADMIN.PROC3 - Changes rolled back.
Who can tell me how to resolve this problem?