Kbase 13134: An index named "DEFAULT"
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
An index named "DEFAULT"
If you create a new file in the Progress database without an index,
Progress creates an automatic primary index called DEFAULT. When
you create this file and then use the Index Editor to view the
indexes, you will see that the DEFAULT index does exist.
Once you define an index for the file, the DEFAULT index is removed
from the list and Progress accesses the data with the new index.
If you use the Progress data dictionary to dump the data definitions
for a file that contains this DEFAULT index, you will see that the
index does not get dumped to the .df file. This is because the
dictionary is smart enough to know that this is not truly a defined
index. It is the "default" index that the dictionary manager uses
to allow data access without an explicitly defined index.
If you build a custom procedure to dump the data definitions from
your database (instead of using the dictionary) you need to
code around this default index named DEFAULT.
If you allow the code to dump this index into the .df file, you
will received errors when you try to load it in to a new database.
This is considered a reserved index name. Therefore, you cannot
load an index into a database with this name.
The error you will get is as follows:
"Keyword DEFAULT may not be used as a name" (329).
To get around this, you have two options, remove the line
to add this index in the .df file, or improve you dump procedure
to dump around this index.
Progress Software Technical Support Note # 13134