Error Deleting Temp tables.

Hello friends, Currently within the application temp tables are created for processing the records by calling function a function to create temporary tables. after which i call a drop table function to drop the temporary table. The syntax is usual . Create temp table xyz with no log for creating temporary table. After which drop table xyz now during dropping of temporary table its giving and error i have checked the sqlca.status the value is -242. Description of error no 242 The database server cannot begin reading a table. Check the accompanying ISAM error code for more information. The problem might be file permissions, a hardware error, or a corrupted system catalog. Unless the ISAM error code or an operating-system message points to another cause, run the bcheck or secheck utility to verify file integrity. Cheers Prateek.Jain --------------------------------- Yahoo! Mail Bring photos to life! New PhotoMail makes sharing a breeze.