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.
DROP PROCEDURE test(int) and
DROP PROCEDURE test(char(250))
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));