Kbase P78565: Loading .df file received error 329 when field name to be indexed was a Progress keyword
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
SYMPTOM(s):
Cannot load (.df) via data dictionary or data admin tool.
Loading data definition file (.df) via the data dictionary or data admin tool generates errors.
Loading .df file via the Data Dictionary and received error during an ADD INDEX statement.
** Error during ADD INDEX <index name> **
Cannot find field to index -
The keyword <name> may not be used as a name. (329)
** The keyword Case may not be used as a name. (329)
Verified one of the fields which make up the index had the name "Case" which is a Progress keyword.
CAUSE:
A Progress keyword was being used as a field name for a field which was part of a multi-component index.
FIX:
Generate a keyword forget list that can be used by the client session when it connects to the database to load the .df. A keyword forget list will allow Progress to take action on a word that Progress has reserved for other purposes.
To create a keyword forget list:
1. Use an editor (like progress, vi, notepad, etc.) to create a keyword forget list.
2. This file should contain a list of all keywords which are reserved for Progress but are contained in the .df file you need to load.
3. Each keyword should be on an individual line in the file.
Example:
CASE
CLIPBOARD
4. Once the keyword forget list file has been created, use the -k startup parameter on the client to point to this file when connecting to the database.
Example: pro sports2000 -k forget
Now the .df file should load without error.