There is a way. Add a column containing appropriated timestamp and delete with a appropriated whrere clause. It is not the job from a database to know what are the last 5 rows ! That is the job for the programmer to know which data is obsolute.
Jan -----Ursprungliche Nachricht----- Von: John Franklin [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 29. Juli 2003 19:30 An: '[EMAIL PROTECTED]' Betreff: RE: sapdb 7.3 install error. The problem was actually in the patches(we installed all the recommended patches for Solaris to date)applied on Solaris. We removed the recommended patches for Solaris and everything worked fine. 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. Regards, Johnf -----Original Message----- From: John Franklin [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 10:15 AM To: '[EMAIL PROTECTED]' Subject: sapdb 7.3 install error. Hi, Installing sapdb-server-sun-32bit-sparc-7_3_0_21.tgz in solaris is giving a bus error (coredump) while extracting SAPDBINT.TGZ. Anybody have a solution or why is this happening? Regards, Johnf _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
