Re: Bad key information in tbspace

Clay Irving (clay@panix.com) wrote: : to receiving the error message is: : ###################################################################### : function del_work() : ###################################################################### : # delete all the records in all work tables. : begin work : lock table zzawippw in exclusive mode : whenever error continue ^^^^^^^^^^^^^^^^^^^^^^^ Why this? Try what happens when you comment that line out. You will probably get an error message which could help pinpoint your problem. : drop index zzawippw1 : drop index zzawippw2 : whenever error call error_alloc : delete from zzawippw : commit work : end function On the other hand, I can't see what's wrong with your statements after all. Maybe some weirdo locking problem? Richard -- +----------------------------+-------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3421 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | | +----------------------------+-------------------------------------------+