The menu option Tools/Re-compile Invalid Procedures will attempt to validate the procedure by issuing an 'alter procedure xxx compile' command. This command will be executed for any procedure or function that is in an invalid state in the schema. Any procedures or functions that are still invalid after the commands have been completed are shown in the results dialog. QAD Data Warehouse Designer does not drop procedures from the database even when their metadata is deleted. Therefore, there may be old procedures present that are in an invalid state. These procedures may be redundant.