Kbase P70501: Error 3388 when creating a temporary table for table with inactive indices
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
SYMPTOM(s):
Error 3388 when creating a temporary table for table with inactive indices
Inversion <index> requested as key for TEMP-TABLE <name>. (3388)
Temporary table defined LIKE database table
Database table has inactive index
Executing the statement:
DEFINE TEMP-TABLE ttTable LIKE dbTable.
Where dbTable is a database table containing inactive indexes.
CAUSE:
The definition for the temporary table attempts to inherit an inactive index from the database table.
All inherited temp-table indexes must be active.
FIX:
Use the USE-INDEX phrase to inherit only those indexes that your temp-table can use OR ensure that the source database table has no inactive indexes.