Re: Unload

Posted in 2000

Topics: Migration, Import/Export & Data Conversion

mars1972@my-deja.com — Thu, 29 Jun 2000 14:52:24 GMT — source: Informix-list mailing list archive (1991-1998)

I can only think of one way, but it requires one extra field. unload to items.unlselect "imast_item", "imast_descext", 0 from imast union select imast_item, imast_descext, 1 from imast order by 3; In article <8jfm5p$9q3$1@slrn.eurobell.net>, "Martyn Shiner" <martyn.shiner@bff-nonwovens.com> wrote: > If I do an unload to text file like > > UNLOAD to items.unl > SELECT imast_item, imast_descext FROM imast> > Can I get the unload file to include column headings? > > Regards > Martyn > > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to mars1972@my-deja.com

Martyn Shiner — Fri, 30 Jun 2000 12:54:14 +0100 — source: Informix-list mailing list archive (1991-1998)

Thanks, Scott Black has used a similar method and both work. Regards Martyn