FW: Change Column data type on a BIG table

Need the Informix version, Remember classic Informix. ;)..... -----Original Message----- From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] Sent: Saturday, April 22, 2000 5:48 AM To: vtnguyen@home.com; informix-list@iiug.org Subject: Re: Change Column data type on a BIG table From: vtnguyen <vtnguyen@home.com> > >The table has about 50 million records. The data type of one of the >columns currently is DECIMAL(13,2). We want to change it to >DECIMAL(9,2). > >What we did was: > Alter table TabA modify colA(9,2)> >And it took forever (the server is running in no-log mode). > >Is there any other better/faster way? What version? Recent versions support in-place alter.... >Another question about SQL in Informix >In Sybase I can do this: > select 'abc..... ' >With Oracle I can do similar as: > select 'abc......' from dual >Can/how I do it on Informix? Huh? Can you have a SELECT statement in Informix? Of course. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com