RES: Whatcha' wanta have?????

Posted in 2004

Topics: Migration, Import/Export & Data Conversion

Julio Cesar — Thu, 19 Feb 2004 15:20:46 -0300 — source: Usenet: comp.databases.informix

Obnoxio, I'm sorry but I can't agree with you, 'cause I have tables with more than 150 columns and doing a query to retry 148 columns, or unload this kind of table really sucks. I actually saw many people complaining about that. Thanks, Julio -----Mensagem original----- De: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] Em nome de Obnoxio The Clown Enviada em: quinta-feira, 19 de fevereiro de 2004 11:21 Para: informix-list@iiug.org Assunto: RE: Whatcha' wanta have????? Julio Cesar wrote: > A except clause in a select * from table would be great. > > This would be very helpful for cases when you have a bunch of columns in a > table and you need either to select or unload almost all of them, > excluding 1, 2 or more columns. That is impressively lazy. -- "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.580 / Virus Database: 367 - Release Date: 6/2/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.580 / Virus Database: 367 - Release Date: 6/2/2004 sending to informix-list

↪ replying to Julio Cesar

Madison Pruet — Thu, 19 Feb 2004 19:47:49 GMT — source: Usenet: comp.databases.informix

I suspect that the issue with this type of request is "Should this be part of the SQL standard, or should this be part of tooling?" M.P. "Julio Cesar" <julio@prodesmaq.com.br> wrote in message news:c12vu0$25d$1@terabinaries.xmission.com... > > Obnoxio, I'm sorry but I can't agree with you, 'cause I have tables with > more than 150 columns and doing a query to retry 148 columns, or unload this > kind of table really sucks. > I actually saw many people complaining about that. > > Thanks, > Julio > > -----Mensagem original----- > De: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] Em > nome de Obnoxio The Clown > Enviada em: quinta-feira, 19 de fevereiro de 2004 11:21 > Para: informix-list@iiug.org > Assunto: RE: Whatcha' wanta have????? > > Julio Cesar wrote: > > > A except clause in a select * from table would be great. > > > > This would be very helpful for cases when you have a bunch of columns in a > > table and you need either to select or unload almost all of them, > > excluding 1, 2 or more columns. > > That is impressively lazy. > > -- > "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" > - Coluche > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.580 / Virus Database: 367 - Release Date: 6/2/2004 > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.580 / Virus Database: 367 - Release Date: 6/2/2004 > > > > sending to informix-list