Archiving Z table
In my ztable I have 10 million records, when user runs the report it takes too much time, for that I have already created one archive table same as my ztable, now I want to insert all ztable data(record) to my zarchive table, I want to keep only one month data in original ztable for that I want to create one archive program to insert all record in my zarhive table and keep 30 days data like: system date to older then 30 days.
Can you give me some idea how to create program? Give me some logic.
Edited by: Julius Bussche on Oct 18, 2008 1:00 AM
Edited by: Julius Bussche on Oct 18, 2008 1:35 AM