> > Script:
> > SET AUTODDL ON;
> > ALTER TABLE CORRESP add COL Varchar(35) NOT NULL;
>
> COMMIT; <---- missing
>
> > update corresp set col='';
> > update corresp set cref='' where cref is null;
> > update corresp set col=cref;
>
> Do a commit here as well.
>
> > alter table corresp drop cref;
> > alter table corresp add CREF Varchar(35) NOT NULL;
>
> Again, COMMIT DDL changes, before using them in a DML
> statement.

Oops, sorry. Missed the SET AUTODDL ON statement. :-/


Thomas