Kbase P58398: How to remove a table using by loading a delta.df?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/9/2003 |
|
Status: Unverified
GOAL:
How to remove a table using by loading a delta.df?
FIX:
Execute code along the following lines:
CREATE ALIAS DICTDB FOR DATABASE test.
DISPLAY LDBNAME("DICTDB").
RUN prodict/load_df.p ("t.df").
DELETE ALIAS DICTDB. /* Optional */
Where the data definition file, ("t.df") is written along the following lines:
DROP TABLE "TableName"
ADD TABLE "TableName"
DUMP-NAME "TableName"
ADD FIELD "FirstField" OF "TableName" AS integer
FORMAT "->,>>>,>>9"
INITIAL "0"
ORDER 10
ADD FIELD "SecondField" OF "TableName" AS character
FORMAT "X(8)"
INITIAL ""
ORDER 20
ADD INDEX "FirstIndex" ON "TableName" UNIQUE
PRIMARY
INDEX-FIELD "FirstField" ASCENDING
.
PSC
cpstream=ISO8859-1
.