Re: Question To All

Jonathan Leffler wrote: > > 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. It does work in dbaccess, however, beware, in version 7.21 at least there is a bug that crashes dbaccess while processing the next SQL statement although the shell-out completes successfully. Art S. Kagel