>The environment:
>
>My main program contains several create table like the one below.
> gcBatchDbf = SUBSTR(SYS(2015), 3, 10)
> CREATE TABLE &gcBatchDbf (Batch_ID c(8), Descript c(40), ;
> m_Pat n(10), Num_Claim n(10), User_Name c(25), Date d(8))
> USE
> USE &gcBatchDbf ALIAS BatchTmp IN 0
>
>The problem:
>
> Sometimes this CREATE TABLE command will create an actual table as
> part of a database container. When I delete the table, the name of
> that table will still be in the database container but it's
> not out there on disk.
> The delete command I used is:
>
> USE IN BatchTmp
> DELETE FILE (gcBatchDbf) + ".Dbf"
>
> The frequency for this to happen is only
> around 10%.
>
>The question:
>
> Is there a way to create a table and then delete it without adding
> it to the database container.
>
>


If you are creating, then deleting, just create a cursor. It will be deleted when you close it.