CODEWITHSUNDEEP
stored-proceduresdb2db2-luw
Paul Z
Paul Z

Reputation: 37

DB2 alter a stored procedure

I am new to DB2 and am stuck in altering a stored procedure.

I am on DB2 9.1 version, AIX.

I wrote following SQL in Toad (free version):

ALTER PROCEDURE THE_USER.BONUS_MAIN ( )
  REPLACE VERSION V1 ( )

  MODIFIES SQL DATA
  CALLED ON NULL INPUT
  INHERIT SPECIAL REGISTERS
  OLD SAVEPOINT LEVEL
BEGIN
 ...
END

I got error message immediately:

ERROR [42601] [IBM][DB2/AIX64] SQL0104N An unexpected token "ALTER PROCEDURE THE_USER.BONUS_MAIN" was found following "BEGIN-OF-STATEMENT". Expected tokens may include: "".

Any tip?

Upvotes: 0

Views: 4173

Answers (1)

Ian Bjorhovde
Ian Bjorhovde

Reputation: 11042

There is no ALTER PROCEDURE statement, you'll need to drop and recreate the procedure. Additionally, you're on such an old version (DB2 9.1 went out of support in April, 2012), you don't even have an option to use CREATE OR REPLACE PROCEDURE....

Upvotes: 1

Related Questions