Re: Column names in unload

Posted in 2000

Colin McGrath — Tue, 19 Sep 2000 12:53:56 -0400 (EDT) — source: Informix-list mailing list archive (1991-1998)

UNLOAD TO....SELECT "col1", col1, "col2", col2, .... so you'll get something like: msg_type|EGE|code|5001|description|There are no more rows in the direction you are going| msg_type|EGE|code|5002|description|There are no rows satisfying the conditions| msg_type|EGE|code|5003|description|There are no rows in the current list| msg_type|EGE|code|5004|description|The current row position contains a deleted row| hktkenneth@my-deja.com wrote: > > Hi there, > > Is it possible to include the column names when I do a > UNLOAD TO....SELECT.... statement? > > Thanks! > > Kenneth > > > Sent via Deja.com http://www.deja.com/ > Before you buy. > > -- Colin McGrath cmm@trac3000.ueci.com Washington Group International, Inc. (215) 422-4144 Philadelphia, PA, USA Any opinions I state are my own and not necessarily those of my employer