Re: Headers in the unload-file

Klaus Nolte wrote: > the sql-statement > > unload to '/tmp/stuff.txt' delimiter ';' > select fname, lname > from stuff;> > will create a file which might look like this: > > Peter;Winston; > Mike;Wiliam; > ... > > Is there any trick to get an additional header line into the file? > (with standard sql! no 4ql, shell-programming, awk ...) > > First-Name;Last-Name; > Peter;Winston; > Mike;Wiliam; > ... SQLCMD from the IIUG archives has this facility, and also the types of each column. I don't know of any other tool that does, but I don't know about every other possible tool. You can get a limited set of info out of the OUTPUT command of ISQL and DB-Access; on the other hand, it does not produce a load format file. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>