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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only