RE: temp tables and serial columns

Hmmm. OK, so I've never tried to alter a temp table... How about a feature request to allow the alteration of temp tables? --EEM ________________________________________ From: Bill64bits [mailto:garage_dba@hotmail.com] Sent: Friday, March 09, 2007 1:25 PM To: Everett Mills; informix-list@iiug.org Subject: Re: temp tables and serial columns as I stated, you cannot do that. You get: Error: Cannot alter temporary table (t) ----- Original Message ----- From: Everett Mills To: informix-list@iiug.org Sent: Friday, March 09, 2007 12:41 PM Subject: RE: temp tables and serial columns Why not do this: Select into temp foo ...; alter table foo modify (my_serial_column integer); --EEM ________________________________________ From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Bill64bits Sent: Friday, March 09, 2007 11:34 AM To: informix-list@iiug.org Subject: temp tables and serial columns We are on IDS 9.4 . One thing that has always annoyed me about serial columns is that they become serial instead of integer when you do a "select into temp x" . If you are trying to duplicate a row for a customer, part, etc, except for the id , you cannot update the temp to change the id to 0 and do an insert back into the table to force a new id to be generated. Neither can you alter the temp table to make the column a plain old integer. You have to create table blah ( ...) with an integer where the serial was and go from there. That is a bit of a hassle if there are many columns. Is there any relief for this issue in IDS 10 or IDS 11 ? Like "into temp t with no serial" or something like that? _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list