>>>>Anyone got a quick way to remove table references in a DBC after the table has been deleted? Or do I need to USE the DBC and do it manually?
>>>>TIA
>>>
>>>You could use REMOVE TABLE command. This way all references will be cleared.
>>
>>Edward,
>>the problem is that if the table does not exist then remove table generates an error and does not remove the reference. Same thing with drop table.
>
>OPEN your database exclusively.
>
>Then do VALIDATE DATABASE RECOVER
>
>it will give you the option to remove the missing table.
Fred,
I never knew of the RECOVER parameter. Maybe I should read the help more often.-) Thanks, it did the trick asking if I wanted to remove the references.
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn