Results 1 to 5 of 5

Thread: drop procedure

  1. #1
    Join Date
    Jan 2004
    Posts
    4

    Unanswered: drop procedure

    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 ?

  2. #2
    Join Date
    Mar 2004
    Location
    Netherlands
    Posts
    183
    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

  3. #3
    Join Date
    Jan 2004
    Posts
    4
    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 ?

  4. #4
    Join Date
    Mar 2004
    Location
    Netherlands
    Posts
    183
    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

  5. #5
    Join Date
    Jan 2004
    Posts
    4
    Thanks, problem is solved.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •