Re: Procedure Delete Script !

Hi Vikas and all members ! Thanks for ur suggestion ... I am doing it the same way as u have suggested...I m running a UNIX shell script which takes server_name as a paramater (as there are many servers) and then dbaccess thru prompt and find out how many procedures are there on that server adn then prepare drop procedure .sql file and then next time run that drop procedure .sql file. I wanted to run it thru dbaccess and see the result. anyway thanks for ur suggestion... Thanks to all others Tata Infotech @Nayan Jain.Com - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - "As soon as you trust yourself, you will know how to live." --- Goethe On Sat, 29 May 1999, Vikas kapare wrote: > Hi, > > Might be this can help you. > > My help is a Guideline. You can develop on it. > > Write a sql which will generate an sql. > > Select " DROP PROCEDURE " || procname || " ; " > from sysprocedures where procid > 1; > > Run this .sql statement through dbaccess command line and output to a > file. > > Again run this file through dbaccess command line. > > By doing this you will be releaved from the pain of writing procedure > names and finding out whether procedure existed or not. > > I have not tested this statement, First test it on some demo database > and then try on your production database. > Regards > Vikas Kapare. >