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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement