Hi all,

How do i do something like:

IF <STORED_PROCEDURE> EXISTS THEN
DROP <STORED_PROCEDURE>
ELSE <CONTINUE_DOING_SOMETHING>

Thanks in advance,

Newbie

DB2 8.1.6 on Windows 2000

You should be able to find the stored procedure name listed in one of the DB2 system catalog tables. The SYSCAT views are documented in the appendix of Vol 1 of the SQL Reference manual.

Hi,

Thanks for the prompt reply. I know SYSCAT.PROCEDURES has the procedure name in PROCNAME column. I want to do a conditional check before i drop/create procedure. I am trying to write a SQL script to deploy TABLES/PROCEDURES/FUNCTIONS on another server.

Newbie

Something like this in MS-SQL:

IF EXISTS (SELECT * FROM sysobjects WHERE name = 'TEST')

DROP TABLE dbo.TEST;

Thanks,
Newbie

Hmm.... Any takers?

Thanks in Advance,
Newbie