-
how to ignore errors when creating stored procedure?
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 DB2 and proceed with creation of the stored procedure? I could put creation of table into dynamic SQL, however, for various reasons I do not want to do that. I am still hopefull there is a way of turning down the stupid DB2 check that prevents me from creating a stored proc.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|