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.