Subject Re: Cannot DROP TABLE due to resource being in use, how to close resource?
Author Bhavbhuti Nathwani
Hi Uwe

--- In, Uwe Grauer
<uwemailmeister@...> wrote:
> I you want to mimic temp tables, add a field "jobid" to your table and
> include your current jobid in all selects/inserts/updates.
> After your current use of the jobid you can delete all records with this
> jobid.
> This way, there is no need to remove your temp-table.
> Reuse your temp table for all future jobs using a different jobid.

Thanks for the suggestion. But I would want to clear this
permanent-temp table :) records else it will really grow with data
that is not at all required.