Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.