In my DB2 stored procs I always first drop the procedure and then do a create statement. Is there any way I could say something like...if exists (select * from sysroutines where routine_name = 'procname') then drop procedure procname; ? I tried this, but the proc doesn't like the IF statement as the first line. Has anyone tried this?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!