I have a very very annoying problem. I want to create a stored procedure, that creates a table and does various things with it. Before creating a stored procedure I check if the table is there. If it is, I first drop it, and then recreate it.
However when I try to create such stored procedure DB2 complains if the table already exists. The stupid thing does not realise that I do the check in the code. Is there anyway to ignore such errors from...
mersis
Last Activity: Jul 25 '07, 02:45 PM
Joined: Jun 22 '07
Location:
-
how to ignore errors when creating stored procedure?
-
I am having exactly the same problem. I need to drop and recreate same stored procedure from time to time. And in the stored procedure I test if a table does not exist I create it. If it does, I drop it and then create a new one. But when I try to recreate the stored proc second time after some tables have already been created by the previous stored proc, creation fails.
Did you find a way to turn that stupid check (that is unable...
No activity results to display
Leave a comment: