Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2008
    Posts
    17

    Unanswered: drop stored procedure?

    Hi all,

    I am trying to drop a stored procedure but I get the following error.

    DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:
    SQL0204N "bqa.procedure" is an undefined name. SQLSTATE=42704

    the command i gave is "drop procedure bqa.procedure "

    Can someone help me please. Thank you all in advance

  2. #2
    Join Date
    Jul 2008
    Posts
    17
    Hi all,

    I got it. I used the command
    " drop specific procedure <schema name>.<specific name>"
    and the procdeure is dropped successfully. thank you all

Posting Permissions

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