Re: Question To All

In article <367009C1.71A1@bloomberg.net>, kagel@bloomberg.net wrote: > 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; TRY MY WAY: isql -s [database] -qr [filename.sql] REGARDS, KAMPOL > > !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 > -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own