var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Table Archiving
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 "|"...