Re: Error Deleting Temp tables.
Posted in 2006
prateek jain said:
> 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.
And what, pray tell, is the accompanying ISAM code?
--
Bye now,
Obnoxio
"Jesus you fucking people are hopeless."
-- Double Enema