Re: Looping in SQL

In article <igZu6.109671$tP3.1704232_at_news1.rdc1.bc.home.com>, bert_at_admicro.bc.ca says...
> I want to keep trying to alter a table until it is successful. If the alter
> table command is not successful, then try the alter command again. If it is
> not successul then do the next SQL command. I need to somehow check the SQL
> error code for alter command if it's OK or not. Can somebody tell me how to
> do this in SQL ??

As far as I know, there is no way to do this is straight SQL; you need a prcoedural language such as PL/SQL or perl.

Doug

-- 
-------------------
Douglas K. O'Leary
Senior System Admin
dkoleary_at_mediaone.net