Re: Question To All
>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
>
>
Couldn't you do somthing like the following in a script?
------------------------------------------------------------
dbaccess database_name << EOF
unload into temptable
select * from table_name;EOF
compress temptable
dbaccess database_name << EOF
unload into temptable2
select * from table2_name;EOF
compress temptable2
... etc ...
Madison Pruet