Re: Question To All

In sh (or ksh): for fname in table1 table2 do dbaccess database_name <<EOF unload to $fname select * from $fnameEOF gzip $fname done Of course you could use another compress utillity. An you could use a file to store the table names. I didn't test it but it should work. Kind Regards, Octav SK wrote: >Hey there, > >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.... > >Thanx in advance for all your help -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com