Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Posts
    3

    Unanswered: dropping a stored procedure created by the Put Routine function

    I have defined a stored procedure on a host, without a C compiler, using the Put Routine function. I used drop procedure to remove it. However whenever I go to recreate the procedure using Put Routine, I get the following error :

    SQL0443N Routine "PUT_ROUTINE_SAR" (specific name "db2udp!put_routine_sar")
    has returned an error SQLSTATE with diagnostic text "-658, 42917, P2241370".
    SQLSTATE=38000


    Why does this happen? How do I drop the procedure so I can recreate it using Put Routine?

  2. #2
    Join Date
    May 2003
    Location
    Phoenix, US
    Posts
    39
    Hi,
    Hope you are using the same command (put_routine) which you have used for the first time.
    Usually you have to specify the owner in the put_routine command and the owner should have necessary privileges.
    Probably you can check in the syscat.procedures to see if the procedure got dropped from this view also.

    HTH

    Thanks
    Sateesh

  3. #3
    Join Date
    Mar 2004
    Posts
    61
    Hi Sateesh,

    I have the same problem, and check the view SYSCAT.PROCEDURES to make sure it is dropped from it. But when I try put routine, the same error is occured as following:

    SQL0443N Routine "PUT_ROUTINE_SAR" (specific name "db2udp!put_routine_sar")
    has returned an error SQLSTATE with diagnostic text "-970, 55009, P1712370".
    SQLSTATE=38000

    How to fix it?

    Thanks,

Posting Permissions

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