Re: unload to file in "append" mode?

Jonathan Leffler <jleffler@earthlink.net> wrote in message news:<Vsv8c.55888$aT1.3168@newsread1.news.pas.earthlink.net>... > John White wrote: > > > The official informix docs online don't discuss an append mode to > > unloading to a file. Any guidance on how to access that? > > There isn't any particularly obvious way to do it -- best guess: > > dbaccess dbname - <<! >>existing.file > unload to "/dev/stdout" select * from somewhere;> ! Works very well. I tend to set up in a file first so something like: dbaccess dbname <sample.sql >> file.txt sample.sql: unload to "/dev/stdout" select * from somewhere;