Hi, I am new to DB2 and I come from an SQL Server background.
In Transact-SQL, when making a Stored Procedure, I always had an "IF EXISTS" clause at the top to check to see if the Stored Procdure already existed and if so Drop it.
How can I do the same thing with a Stored Procedure in DB2?
I have a database project in Visual Studio.Net and it is connected to the AS400. When I make a Stored Procedure, everything is fine. However, whenever I modify the Stored Procedure and Re-apply it to the AS400, it correctly errors and states that the Stored Procedure exists already.
Thanks in advance