When doing a DB Info/Routine, the DB shows two procedures with the same name, but when viewing them, their content is different (but not the parameters). I want to drop these 2 procedures but the drop gives error 9700. What can I do ?

You probably are using IDS 9. This object-relational version can have functions with the same name, but with other input parameters (In the OO world this is called polymorphism). It is wise to give them a specific name when creating them (this is an extra option).

But you can always maintain/drop them by specifying the procedure name and their parameter datatypes.

For example:
DROP PROCEDURE test(int) and
DROP PROCEDURE test(char(250))

Hope this helps,

Rob Prop

I have tried this, but Informix keeps on rejecting because of a syntax error.
This is what I do:
drop procedure end_period_bks_cr
(period CHAR(6),date_time CHAR(14),transid char(20),fct_code1 char(3), fct_code2 char(3));

What is wrong ?

Only specify datatypes, not the parameter name, so:

drop procedure end_period_bks_cr (CHAR(6),CHAR(14),char(20),char(3), char(3));

Hope this helps,

Rob Prop

Thanks, problem is solved.