Ignoring Error in SQL
Hi all,
I have a .sql file which i run in dbaccess
##-------------Contents of .sql file------------##
drop procedure abc;
drop procedure def;
drop procedure ghi;
##------------- EOF ---------------------------##
Now what happens is tht when i run this it drops the procedures in tht
database. But if in case procedure 'def' is not at all there.It stops and
gives an error. what i want is tht it should proceed ahead and delete next
procedure 'ghi'
It should not stop if it encounters error.
TIA,
Nayan !
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
"The question is not whether we will die, but how we will live."
-Joan Borysenko