John Franklin wrote: > ... > I have another question? Is there a easy way to delete the > oldest 5 records > from a table in SAPDB? When the number of records in a table exceeds a > threshold I want to remove the oldest ones.
in pure SQL I would say: DECLARE curs CURSOR FOR SELECT .. FROM my_table ORDER BY <that column which has the knowledge of age of record> FOR UPDATE loop for <number of oldest records to be deleted> FETCH curs INTO <parameter, which are of no use> DELETE my_table WHERE CURRENT OF curs In ODBC there are options to tell a resultset to be updateable and then the loop can be done Or if you know the oldest age you want to store: DELETE my_table WHERE <that column which has the knowledge of age of record> < <the first date you want to have in your table> Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
