Re: Question To All

On Wed, 9 Dec 1998, SK wrote: > I unload frequently updated tables twice a day through an SQL script, > i.e. "unload to <file_name> select * from <table_name>". Some files > are more then 100MBs. > Is there any way that though SQL script, right after unloading the > table i can compress the file and then start unloading the next table > and so on.... dbaccess dbase - <<! unload to "100mb.file" select * from whereever;!gzip 100mb.file unload ... ... ! Not documented; certainly works in ISQL, probably in DB-Access. Does not work from the menu system -- only in the script mode. Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix v0.60 -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn