Hi,

I have a table of size 10 GB. It contains the data from 1997. Now I want to achive the table for different financial year. How to do that?

I don't know how your table looks like(you should provide more information)
but you can use the following command in the script in the loop and archive table by financial years:

output to "filename.dat" select * from table where some_date_column >some_date and some_date_column< some_date;

Thanks a lot. It will fulfill my requirement

use the unload or HPL utils...
if you execute this select with OUTPUT will be a little hard to load this data again on IDS...
if you use the UNLOAD or HPL the data will be exported with delimiters "|"...